Index: openacs-4/packages/lars-blogger/tcl/metaweblog-api-procs-postgresql.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/lars-blogger/tcl/metaweblog-api-procs-postgresql.xql,v
diff -u -r1.1 -r1.2
--- openacs-4/packages/lars-blogger/tcl/metaweblog-api-procs-postgresql.xql	8 Dec 2003 05:55:53 -0000	1.1
+++ openacs-4/packages/lars-blogger/tcl/metaweblog-api-procs-postgresql.xql	14 Dec 2003 11:10:44 -0000	1.2
@@ -6,18 +6,17 @@
 <fullquery name="metaWeblog.getRecentPosts.get_n_entries">
       <querytext>
         select entry_id,
-               to_char(entry_date, 'YYYY-MM-DD') as entry_date,
+               to_char(entry_date, 'YYYY-MM-DD HH24:MI:SS') as entry_date_ansi,
                title,
-			   c.name as category,
+               c.name as category,
                content,
-               to_char(posted_date , 'HH24:MI') as posted_time_pretty
-		    from   pinds_blog_entries e left join pinds_blog_categories c 
-                   using (category_id)
-		    where  e.package_id = :package_id
-		    and    draft_p = 'f'
-		    and    deleted_p = 'f'
-		    order  by entry_date desc, posted_date desc
-            limit $num_posts
+        from   pinds_blog_entries e left outer join 
+	       pinds_blog_categories c  using (category_id)
+    	where  e.package_id = :package_id
+    	and    draft_p = 'f'
+    	and    deleted_p = 'f'
+    	order  by entry_date desc
+        limit $num_posts
       </querytext>
 </fullquery>