Search Postgresql Archives

boolean operator on interval producing strange results

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



We updated our production server to postgresql 8.2.3 yesterday.  This
query is giving different results than on our development box:

development:
# select ((now() - '1 day'::interval)::timestamp - now()) < 0;
?column?
----------
t
(1 row)

production
#  select ((now() - '1 day'::interval)::timestamp - now()) < 0;
?column?
----------
f  <-- looks busted to me
(1 row)

both servers are redhat fc4, same version postgresql. only difference
I know of is development is a little behind on yum update.  can
anybody think of anything that might have influenced this?

merlin


[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux