On 2/20/07, Tom Lane <[EMAIL PROTECTED]> wrote:
"Merlin Moncure" <[EMAIL PROTECTED]> writes:
> On 2/19/07, Tom Lane <[EMAIL PROTECTED]> wrote:
>> "Merlin Moncure" <[EMAIL PROTECTED]> writes:
>>> # select ((now() - '1 day'::interval)::timestamp - now()) < 0;
>>> ?column?
>>> --
>>> f <--
"Merlin Moncure" <[EMAIL PROTECTED]> writes:
> On 2/19/07, Tom Lane <[EMAIL PROTECTED]> wrote:
>> "Merlin Moncure" <[EMAIL PROTECTED]> writes:
>>> # select ((now() - '1 day'::interval)::timestamp - now()) < 0;
>>> ?column?
>>> --
>>> f <-- looks busted to me
>>> (1 row)
>>
>> If you'd ca
--Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Merlin Moncure
Sent: Tuesday, February 20, 2007 8:30 AM
To: Tom Lane
Cc: postgres general
Subject: Re: [GENERAL] boolean operator on interval producing strange
results
On 2/19/07, Tom Lane <[EMAIL P
On 2/19/07, Tom Lane <[EMAIL PROTECTED]> wrote:
"Merlin Moncure" <[EMAIL PROTECTED]> writes:
> # select ((now() - '1 day'::interval)::timestamp - now()) < 0;
> ?column?
> --
> f <-- looks busted to me
> (1 row)
If you'd casted to timestamptz then I'd agree this is busted.
As-is, it m
"Merlin Moncure" <[EMAIL PROTECTED]> writes:
> # select ((now() - '1 day'::interval)::timestamp - now()) < 0;
> ?column?
> --
> f <-- looks busted to me
> (1 row)
If you'd casted to timestamptz then I'd agree this is busted.
As-is, it might have something to do with your timezone setti
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)::timest
