Index: openacs-4/packages/edit-this-page/tcl/etp-procs-postgresql.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/edit-this-page/tcl/etp-procs-postgresql.xql,v
diff -u -N -r1.3 -r1.4
--- openacs-4/packages/edit-this-page/tcl/etp-procs-postgresql.xql 31 Oct 2001 05:13:54 -0000 1.3
+++ openacs-4/packages/edit-this-page/tcl/etp-procs-postgresql.xql 19 Nov 2001 05:35:50 -0000 1.4
@@ -140,4 +140,21 @@
+
+
+ etp__get_attribute_value(r.revision_id, $attribute_id)
+
+
+
+
+
+ i.item_id, i.name, tree_sortkey as sort_order,
+ to_char(r.publish_date, 'Mon DD, YYYY') as publish_date,
+ (select object_type from acs_objects
+ where object_id = i.item_id) as object_type,
+ etp__get_relative_url(i.item_id, i.name) as url,
+ etp__get_title(i.item_id, r.title) as title,
+ etp__get_description(i.item_id, r.description) as description
+
+