postgresql7.1
select forums_messages.*,
person__name(forums_messages.user_id) as user_name,
to_char(forums_messages.posting_date_ansi, 'YYYY-MM-DD HH24:MI:SS') as posting_date_ansi,
100 as the_score
from forums_messages,
forums_forums
where forums_messages.forum_id = forums_forums.forum_id
and forums_forums.package_id = :package_id
and forums_messages.state = 'approved'
and ( forums_messages.subject like ('%' || :search_text || '%')
or forums_messages.content like ('%' || :search_text || '%')
or person__name(forums_messages.user_id) like ('%' || :search_text || '%')
)
order by the_score desc,
forums_messages.posting_date desc
select forums_messages.*,
person__name(forums_messages.user_id) as user_name,
to_char(forums_messages.posting_date_ansi, 'YYYY-MM-DD HH24:MI:SS') as posting_date_ansi,
100 as the_score
from forums_messages,
forums_forums
where forums_forums.forum_id = :forum_id
and forums_forums.package_id = :package_id
and forums_messages.forum_id = forums_forums.forum_id
and forums_messages.state = 'approved'
and ( forums_messages.subject like ('%' || :search_text || '%')
or forums_messages.content like ('%' || :search_text || '%')
or person__name(forums_messages.user_id) like ('%' || :search_text || '%')
)
order by the_score desc,
forums_messages.posting_date desc