Index: openacs-4/packages/acs-admin/www/users/one-postgresql.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/acs-admin/www/users/Attic/one-postgresql.xql,v
diff -u -r1.1 -r1.2
--- openacs-4/packages/acs-admin/www/users/one-postgresql.xql	29 Apr 2001 00:47:48 -0000	1.1
+++ openacs-4/packages/acs-admin/www/users/one-postgresql.xql	29 Apr 2001 01:28:46 -0000	1.2
@@ -5,11 +5,12 @@
 
 <fullquery name="user_contributions">      
       <querytext>
-      select at.pretty_name, at.pretty_plural, a.creation_date, acs_object__name(a.object_id) object_name
-from acs_objects a, acs_object_types at
-where a.object_type = at.object_type
-and a.creation_user = :user_id
-order by object_name, creation_date
+      select at.pretty_name, at.pretty_plural, a.creation_date,
+          acs_object__name(a.object_id) as object_name
+      from acs_objects a, acs_object_types at
+      where a.object_type = at.object_type
+          and a.creation_user = :user_id
+      order by object_name, creation_date
       </querytext>
 </fullquery>