postgresql7.1 select to_char(current_timestamp,'DD Mon YYYY hh12:MI am') select e.entry_id, e.title, e.content, to_char(e.posted_date, 'YYYY-MM-DD HH24:MI:SS') as posted_time_ansi, c.name as category from pinds_blog_entries e left outer join pinds_blog_categories c using (category_id) where e.package_id = :package_id and e.draft_p = 'f' and e.deleted_p = 'f' order by e.entry_date desc, e.posted_date desc limit 10 select e.entry_id, e.title, e.content, to_char(e.posted_date, 'YYYY-MM-DD HH24:MI:SS') as posted_time_ansi, c.name as category from pinds_blog_entries e join acs_objects o on (o.object_id = e.entry_id) join users u on (u.user_id = o.creation_user) left outer join pinds_blog_categories c using (category_id) where e.package_id = :package_id and o.creation_user = :user_id and e.draft_p = 'f' and e.deleted_p = 'f' order by e.entry_date desc, e.posted_date desc limit 10 select coalesce (date_part('epoch', max(posted_date::timestamptz) ),0) as last_update from pinds_blog_entries where package_id = :package_id and draft_p = 'f' and deleted_p = 'f' select coalesce (date_part('epoch', max(e.posted_date::timestamptz) ),0) as last_update from pinds_blog_entries e join acs_objects o on (o.object_id = e.entry_id) where e.package_id = :package_id and o.creation_user = :user_id and e.draft_p = 'f' and e.deleted_p = 'f'