postgresql7.1
select message_id,
forum_id,
subject,
content,
person__name(user_id) as user_name,
party__email(user_id) as user_email,
user_id,
forums_forum__name(forum_id) as forum_name,
forums_message__root_message_id(forums_messages.message_id) as root_message_id,
(select subject
from forums_messages fm2
where message_id = forums_message__root_message_id(forums_messages.message_id)) as root_subject,
to_char(posting_date, 'Mon DD YYYY HH24:MI:SS') as posting_date,
tree_sortkey,
parent_id,
state,
html_p
from forums_messages
where message_id= :message_id
select site_node__url(node_id)
from site_nodes
where object_id = (select package_id
from forums_forums
where forums_forums.forum_id = :forum_id)
declare begin
forums_message__delete_thread(:message_id);
end;
declare begin
forums_message__thread_close(:message_id);
end;
declare begin
forums_message__thread_open(:message_id);
end;