Folks,
Potentially a real problem bug in 7.2:
staffos=# select version(); version
-------------------------------------------------------------PostgreSQL 7.2 on i686-pc-linux-gnu, compiled by GCC
2.95.3
(1 row)
staffos=# select ('6 days'::INTERVAL + current_timestamp); ?column?
---------------------2002-02-25 00:00:00
(1 row)
staffos=# select (current_timestamp + '6 days'::INTERVAL); ?column?
-------------------------------2002-03-03 20:07:52.105254-08
(1 row)
-Josh
______AGLIO DATABASE SOLUTIONS___________________________ Josh Berkus Complete
informationtechnology josh@agliodbs.com and data management solutions (415) 565-7293 for law firms, small
businesses fax 621-2533 and non-profit organizations. San Francisco