Index: openacs-4/packages/wp-slim/www/index-postgresql.xql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/wp-slim/www/index-postgresql.xql,v diff -u -r1.3 -r1.4 --- openacs-4/packages/wp-slim/www/index-postgresql.xql 28 Aug 2003 09:42:00 -0000 1.3 +++ openacs-4/packages/wp-slim/www/index-postgresql.xql 22 Sep 2003 18:41:27 -0000 1.4 @@ -3,20 +3,12 @@ postgresql7.1 - - - - and ao.creation_date >= (current_timestamp - cast('$show_age days' as interval)) - - - - select i.item_id as pres_item_id, pres.pres_title, - to_char(ao.creation_date, 'Month DD, YYYY') as creation_date, + ao.creation_date as creation_date, ao.creation_user, p.first_names || ' ' || p.last_name as full_name from cr_items i, cr_wp_presentations pres, persons p, acs_objects ao @@ -36,7 +28,7 @@ select i.item_id as pres_item_id, p.pres_title, - to_char(ao.creation_date, 'Month DD, YYYY') as creation_date + ao.creation_date as creation_date from cr_items i, cr_wp_presentations p, acs_objects ao where i.live_revision = p.presentation_id and ao.object_id = i.item_id @@ -53,7 +45,7 @@ select i.item_id as pres_item_id, pres.pres_title, - to_char(ao.creation_date, 'Month DD, YYYY') as creation_date, + ao.creation_date as creation_date, ao.creation_user, p.first_names || ' ' || p.last_name as full_name, acs_permission__permission_p(i.item_id, :user_id, 'wp_edit_presentation') as edit_p