Index: openacs-4/packages/lars-blogger/tcl/rss-procs-postgresql.xql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/lars-blogger/tcl/rss-procs-postgresql.xql,v diff -u -r1.1.2.1 -r1.1.2.2 --- openacs-4/packages/lars-blogger/tcl/rss-procs-postgresql.xql 24 Oct 2002 08:57:25 -0000 1.1.2.1 +++ openacs-4/packages/lars-blogger/tcl/rss-procs-postgresql.xql 4 Nov 2002 16:23:12 -0000 1.1.2.2 @@ -34,8 +34,10 @@ - select coalesce (date_part('epoch',max(posted_date)),0) as last_update - from pinds_blog_entries + select coalesce (date_part('epoch', + max(posted_date::timestamp with time zone) + ),0) as last_update + from pinds_blog_entries where package_id = :package_id and draft_p = 'f' and deleted_p = 'f'