Index: openacs-4/packages/edit-this-page/templates/news-index-postgresql.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/edit-this-page/templates/news-index-postgresql.xql,v
diff -u -r1.2 -r1.3
--- openacs-4/packages/edit-this-page/templates/news-index-postgresql.xql 18 Dec 2001 19:28:00 -0000 1.2
+++ openacs-4/packages/edit-this-page/templates/news-index-postgresql.xql 11 Aug 2003 20:38:29 -0000 1.3
@@ -4,20 +4,19 @@
- current_timestamp between to_date(attributes.release_date, 'Month DD, YYYY') and
- to_date(attributes.archive_date, 'Month DD, YYYY')
+ current_timestamp between attributes.release_date and attributes.archive_date
- current_timestamp >= to_date(attributes.archive_date, 'Month DD, YYYY')
+ current_timestamp >= attributes.archive_date
- to_date(attributes.release_date, 'Month DD, YYYY') desc
+ attributes.release_date desc