postgresql7.1 select forums_messages.*, person__name(forums_messages.user_id) as user_name, to_char(forums_messages.posting_date, '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 upper(forums_messages.subject || ' ' || forums_messages.content || ' ' || person__name(forums_messages.user_id)) like '%' || upper(:search_text) || '%' order by forums_messages.posting_date desc select forums_messages.*, person__name(forums_messages.user_id) as user_name, to_char(forums_messages.posting_date, '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 upper(forums_messages.subject || ' ' || forums_messages.content || ' ' || person__name(forums_messages.user_id)) like '%' || upper(:search_text) || '%' order by forums_messages.posting_date desc