postgresql7.1
select count(*) from chat_msgs
where room_id = :room_id
select chat_room__delete_all_msgs(:room_id)
select chat_transcript__del(:transcript_id)
select chat_room__message_post(:room_id, :msg, :creation_user, :creation_ip)
select chat_room__del(:room_id)