Index: openacs-4/packages/survey/www/index-postgresql.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/survey/www/index-postgresql.xql,v
diff -u -r1.1 -r1.2
--- openacs-4/packages/survey/www/index-postgresql.xql	16 Sep 2002 00:00:23 -0000	1.1
+++ openacs-4/packages/survey/www/index-postgresql.xql	23 Nov 2002 05:18:14 -0000	1.2
@@ -1,12 +1,13 @@
 <?xml version="1.0"?>
 
 <queryset>
+<rdbms><type>postgresql</type><version>7.1</version></rdbms>
 
 <fullquery name="survey_select">
 	<querytext>
 
 select s.survey_id, s.name, s.editable_p, s.single_response_p,
-       sr.response_id, sr.creation_date
+       sr.response_id, to_char(sr.creation_date, 'Month FMDD, YYYY') as creation_date
   from surveys s left outer join 
        (select survey_id, response_id, creation_date
           from survey_responses_latest