postgresql7.1 select forums_forums_enabled.*, (select count(*) from forums_messages where forums_messages.forum_id = forums_forums_enabled.forum_id and parent_id is null) as n_threads, to_char(last_post, 'YYYY-MM-DD HH24:MI:SS') as last_post_ansi, case when last_post > (now() - interval '1 day') then 't' else 'f' end as new_p from forums_forums_enabled where forums_forums_enabled.package_id = :package_id and ( forums_forums_enabled.posting_policy = 'open' or forums_forums_enabled.posting_policy = 'moderated' or 't' = acs_permission__permission_p(forums_forums_enabled.forum_id, :user_id,'forum_read') ) order by forums_forums_enabled.name