1 CREATE OR REPLACE FUNCTION unread_posts(IN uid int, OUT unread int, OUT "new" int) AS
3 SELECT count(*)::int AS unread
4 ,count(NULLIF(fp.time > (SELECT max(time) FROM forum_thread_visits WHERE uid = $1),FALSE))::int AS new
8 LEFT OUTER JOIN (SELECT * FROM forum_thread_visits WHERE uid = $1)
10 WHERE COALESCE(ft.mtime > ftv.time,TRUE)
12 fbid IN (SELECT fbid FROM forum_access WHERE gid IN (SELECT groups($1)))
13 ) OR ft.ftid IN (SELECT ftid FROM forum_priv_access WHERE uid = $1)
16 JOIN forum_posts fp USING (ftid)
17 WHERE COALESCE(fp.time > ft.time, TRUE)
18 $SQL$ LANGUAGE sql STABLE;