1 SET client_min_messages TO warning;
3 CREATE OR REPLACE FUNCTION forums_search(text, integer, text, boolean) RETURNS SETOF forums_results AS '
9 FOR data IN SELECT forum.msg_id, ts_headline(forum.subject, q) AS subject, forum.post_date, users.realname, forum_group_list.forum_name
10 FROM forum, users, forum_group_list, to_tsquery($1) AS q
11 WHERE users.user_id = forum.posted_by
12 AND forum_group_list.group_forum_id = forum.group_forum_id
13 AND forum_group_list.is_public <> 9
14 AND forum_group_list.group_forum_id IN (\'$3\')
15 AND forum.msg_id IN (SELECT msg_id FROM forum_idx, to_tsquery($1) AS q
16 WHERE group_id = $2 AND vectors @@ q ORDER BY rank(vectors, q) DESC) LOOP
20 FOR data IN SELECT forum.msg_id, ts_headline(forum.subject, q) AS subject, forum.post_date, users.realname, forum_group_list.forum_name
21 FROM forum, users, forum_group_list, to_tsquery($1) AS q
22 WHERE users.user_id = forum.posted_by
23 AND forum_group_list.group_forum_id = forum.group_forum_id
24 AND forum_group_list.is_public <> 9
25 AND forum_group_list.group_forum_id IN (\'$3\')
26 AND forum_group_list.is_public = 1
27 AND forum.msg_id IN (SELECT msg_id FROM forum_idx, to_tsquery($1) AS q
28 WHERE group_id = $2 AND vectors @@ q ORDER BY rank(vectors, q) DESC) LOOP
34 FOR data IN SELECT forum.msg_id, ts_headline(forum.subject, q) AS subject, forum.post_date, users.realname, forum_group_list.forum_name
35 FROM forum, users, forum_group_list, to_tsquery($1) AS q
36 WHERE users.user_id = forum.posted_by
37 AND forum_group_list.group_forum_id = forum.group_forum_id
38 AND forum_group_list.is_public <> 9
39 AND forum.msg_id IN (SELECT msg_id FROM forum_idx, to_tsquery($1) AS q
40 WHERE group_id = $2 AND vectors @@ q ORDER BY rank(vectors, q) DESC) LOOP
44 FOR data IN SELECT forum.msg_id, ts_headline(forum.subject, q) AS subject, forum.post_date, users.realname, forum_group_list.forum_name
45 FROM forum, users, forum_group_list, to_tsquery($1) AS q
46 WHERE users.user_id = forum.posted_by
47 AND forum_group_list.group_forum_id = forum.group_forum_id
48 AND forum_group_list.is_public <> 9
49 AND forum_group_list.is_public = 1
50 AND forum.msg_id IN (SELECT msg_id FROM forum_idx, to_tsquery($1) AS q
51 WHERE group_id = $2 AND vectors @@ q ORDER BY rank(vectors, q) DESC) LOOP