Postgres Pro
Downloads
Home   >   mailing lists

Timestamp operator error - Mailing list pgsql-sql

From Josh Berkus
Subject Timestamp operator error
Date
Msg-id web-810117@davinci.ethosmedia.com
Whole thread Raw
Responses Re: Timestamp operator error  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-sql
Tree view 
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

pgsql-sql by date:

Previous
From: "Dan Langille"
Date:
Subject: Re: record iteration within SQL
Next
From: Tom Lane
Date:
Subject: Re: Timestamp operator error