Postgres Pro
Downloads
Home   >   mailing lists

Re: boolean operator on interval producing strange results - Mailing list pgsql-general

From Tom Lane
Subject Re: boolean operator on interval producing strange results
Date
Msg-id 19556.1171945022@sss.pgh.pa.us
Whole thread Raw
In response to boolean operator on interval producing strange results  ("Merlin Moncure" <mmoncure@gmail.com>)
Responses Re: boolean operator on interval producing strange results  ("Merlin Moncure" <mmoncure@gmail.com>)
List pgsql-general
Tree view 
"Merlin Moncure" <mmoncure@gmail.com> 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 setting,
which you didn't mention?

            regards, tom lane

pgsql-general by date:

Previous
From: "Justin Dearing"
Date:
Subject: Syncing postgres data with Pocket PC
Next
From: DANTE Alexandra
Date:
Subject: Re: RPM compat-postgresql-libs-4-2 for IA-64