Index: openacs-4/packages/cms/www/modules/items/revisions-postgresql.xql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/cms/www/modules/items/revisions-postgresql.xql,v diff -u -N -r1.2 -r1.3 --- openacs-4/packages/cms/www/modules/items/revisions-postgresql.xql 9 Jun 2001 01:06:04 -0000 1.2 +++ openacs-4/packages/cms/www/modules/items/revisions-postgresql.xql 16 Nov 2004 22:32:48 -0000 1.3 @@ -36,11 +36,12 @@ revision_id, trim(title) as title, trim(description) as description, + publish_date, content_revision__get_number(revision_id) as revision_number from cr_revisions r where - r.item_id = $item_id + r.item_id = :item_id order by revision_number desc