| From: | "Josh Berkus" <josh(at)agliodbs(dot)com> |
|---|---|
| To: | pgsql-sql(at)postgresql(dot)org |
| Subject: | Timestamp operator error |
| Date: | 2002-02-26 04:10:29 |
| Message-ID: | web-810117@davinci.ethosmedia.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-sql |
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 information technology josh(at)agliodbs(dot)com
and data management solutions (415) 565-7293
for law firms, small businesses fax 621-2533
and non-profit organizations. San Francisco
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2002-02-26 04:28:14 | Re: Timestamp operator error |
| Previous Message | Dan Langille | 2002-02-25 23:52:39 | Re: record iteration within SQL |