Index: openacs-4/packages/lars-blogger/tcl/entry-procs-postgresql.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/lars-blogger/tcl/entry-procs-postgresql.xql,v
diff -u -r1.1 -r1.2
--- openacs-4/packages/lars-blogger/tcl/entry-procs-postgresql.xql	27 Jan 2003 16:19:15 -0000	1.1
+++ openacs-4/packages/lars-blogger/tcl/entry-procs-postgresql.xql	28 Aug 2003 09:41:55 -0000	1.2
@@ -7,11 +7,13 @@
         <querytext>
 		    select b.entry_id,  
                            b.title, 
+                           b.title_url, 
                            b.content, 
                            b.content_format, 
                            b.draft_p, 
+			   o.creation_user as user_id,
                            to_char(b.entry_date, 'YYYY-MM-DD') as entry_date,
-		           to_char(b.entry_date, 'fmDayfm, Month fmDDfm, YYYY') as entry_date_pretty, 
+		           to_char(b.entry_date, 'fmDayfm, fmMonthfm fmDDfm, YYYY') as entry_date_pretty, 
         		   p.first_names as poster_first_names,
 		           p.last_name as poster_last_name,
 		           to_char(b.posted_date , 'HH24:MI') as posted_time_pretty,
@@ -29,4 +31,14 @@
         </querytext>
     </fullquery>
 
+    <fullquery name="lars_blogger::entry::publish.update_entry">
+        <querytext>
+		    update pinds_blog_entries
+		    set    entry_date = date_trunc('day', current_timestamp),
+		           draft_p = 'f',
+		           posted_date = current_timestamp
+		    where  entry_id = :entry_id
+        </querytext>
+    </fullquery>
+
 </queryset>