Following the example provided, this still appears to be a bug. The results=
are very different when we run the example. We did notice that although no=
w() failed, changing this to 'now()'::date works (using single quotes aroun=
d now()). I will be working with our administrators to review patches and v=
ersion levels.=20
Also, apparently we are not truly a Postgres database, but EMC's Greenplum =
database. I will be working with our admins and EMC, unless someone in Post=
gres can point out a specific version that resolved this issue.=20
drop table if exists t;
create table t=20
(id int primary key,=20
d1 date not null,=20
d2 date not null);
=20=20=20
insert into t
values
(1, now(), current_date),
(2, localtimestamp::date, date_in(date_out(current_date))),
(3, 'now()'::date, clock_timestamp()::DATE);
select * from t order by 1;
id | d1 | d2=20=20=20=20=20
----+------------+------------
1 | 1999-12-31 | 1999-12-31
2 | 1999-12-31 | 1999-12-31
3 | 2012-01-11 | 2012-01-11
Additional information - select version();
"PostgreSQL 8.2.15 (Greenplum Database 4.1.1.5 build 1) on x86_64-unknown-l=
inux-gnu, compiled by GCC gcc (GCC) 4.4.2 compiled on Sep 20 2011 11:09:08"
John Udick | Enterprise Data Warehouse Development
-----Original Message-----
From: Tom Lane [mailto:tgl@sss.pgh.pa.us]=20
Sent: Wednesday, January 11, 2012 8:21 AM
To: John Udick
Cc: pgsql-bugs@postgresql.org
Subject: Re: [BUGS] BUG #6391: insert does not insert correct value=20
john.udick@zionsbancorp.com writes:
> I would expect that at the time/date of the of now() and clock_timestamp()
> to be equal; which they are.
Well, they are not in general, but that doesn't appear to be your
problem. You have not shown us a reproducible test case, but I wonder
whether your table has a trigger that is doing date_trunc('year',...)
or something like that on the column value.
regards, tom lane
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D
THIS ELECTRONIC MESSAGE, INCLUDING ANY ACCOMPANYING DOCUMENTS, IS CONFIDENT=
IAL and may contain information that is privileged and exempt from disclosu=
re under applicable law. If you are neither the intended recipient nor resp=
onsible for delivering the message to the intended recipient, please note t=
hat any dissemination, distribution, copying or the taking of any action in=
reliance upon the message is strictly prohibited. If you have received thi=
s communication in error, please notify the sender immediately. Thank you.
