Index: openacs-4/packages/lars-blogger/www/blog-postgresql.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/lars-blogger/www/blog-postgresql.xql,v
diff -u -r1.3.2.2 -r1.3.2.3
--- openacs-4/packages/lars-blogger/www/blog-postgresql.xql	13 Mar 2003 14:30:31 -0000	1.3.2.2
+++ openacs-4/packages/lars-blogger/www/blog-postgresql.xql	13 Mar 2003 17:05:51 -0000	1.3.2.3
@@ -3,25 +3,38 @@
 <queryset>
     <rdbms><type>postgresql</type><version>7.1</version></rdbms>
 
-	<partialquery name="date_clause_archive">
+	<partialquery name="date_clause_archive_month">
 		<querytext>
 			date_trunc(:archive_interval, entry_date) = :archive_date
 		</querytext>
 	</partialquery>
 
+	<partialquery name="date_clause_archive_day">
+		<querytext>
+			date_trunc(:archive_interval, entry_date) = :archive_date
+		</querytext>
+	</partialquery>
+
 	<partialquery name="date_clause_default">
 		<querytext>
 			entry_date > current_timestamp - interval '30 days'
 		</querytext>
 	</partialquery>
 
+	<partialquery name="limit_clause">
+		<querytext>
+                    limit 3
+		</querytext>
+	</partialquery>
+
     <fullquery name="blog">
         <querytext>
 		    select entry_id,
 		           to_char(entry_date, 'fmDayfm, Month fmDDfm, YYYY') as entry_date_pretty, 
 		           to_char(entry_date, 'YYYY/MM/DD/') as entry_archive_url,
 		           to_char(entry_date, 'YYYY-MM-DD') as entry_date,
 		           title,
+                           title_url,
 		           content,
                            content_format,
 		           draft_p,
@@ -40,6 +53,7 @@
 		    and    draft_p = 'f'
 		    and    deleted_p = 'f'
 		    order  by entry_date desc, posted_date desc
+                    $limit_clause
         </querytext>
     </fullquery>