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.6 -r1.7
--- openacs-4/packages/lars-blogger/tcl/rss-procs-postgresql.xql	11 Dec 2003 21:40:05 -0000	1.6
+++ openacs-4/packages/lars-blogger/tcl/rss-procs-postgresql.xql	14 Dec 2003 11:10:44 -0000	1.7
@@ -14,14 +14,14 @@
             select e.entry_id,
                    e.title, 
                    e.content,
-                   to_char(e.posted_date, 'YYYY-MM-DD HH24:MI:SS') as posted_time_ansi,
+                   to_char(e.entry_date, 'YYYY-MM-DD HH24:MI:SS') as entry_date_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
+            order  by e.entry_date desc
             limit  10
         </querytext>
     </fullquery>
@@ -31,7 +31,7 @@
             select e.entry_id,
                    e.title, 
                    e.content,
-                   to_char(e.posted_date, 'YYYY-MM-DD HH24:MI:SS') as posted_time_ansi,
+                   to_char(e.entry_date, 'YYYY-MM-DD HH24:MI:SS') as entry_date_ansi,
                    c.name as category
             from   pinds_blog_entries e join 
                    acs_objects o on (o.object_id = e.entry_id) join 
@@ -41,15 +41,15 @@
             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
+            order  by e.entry_date desc
             limit  10
         </querytext>
     </fullquery>
 
     <fullquery name="lars_blog__rss_lastUpdated.get_last_update">
         <querytext>
                 select coalesce (date_part('epoch',
-                                max(posted_date::timestamptz)
+                                max(entry_date::timestamptz)
                                 ),0) as last_update
                 from   pinds_blog_entries
 	        where  package_id = :package_id
@@ -61,7 +61,7 @@
     <fullquery name="lars_blog__rss_lastUpdated.get_last_user_update">
         <querytext>
                 select coalesce (date_part('epoch',
-                                max(e.posted_date::timestamptz)
+                                max(e.entry_date::timestamptz)
                                 ),0) as last_update
                 from   pinds_blog_entries e join 
 		       acs_objects o on (o.object_id = e.entry_id)