On Thu, Jun 02, 2005 at 13:26:32 +0200,
Havasvölgyi Ottó <[EMAIL PROTECTED]> wrote:
>
> I tried to simulate this unexpected result, but with no success. Here in
> Hungary we had daylight saving this year on the 27th of March
> (http://webexhibits.org/daylightsaving/b.html). So I tried these:
>
Hi,
- Original Message -
From: "Bruno Wolff III" <[EMAIL PROTECTED]>
To: "Havasvölgyi Ottó" <[EMAIL PROTECTED]>
Cc:
Sent: Thursday, June 02, 2005 3:53 AM
Subject: Re: [GENERAL] interval integer comparison
> On Thu, Jun 02, 2005 at 01:54:12 +0200,
>
On Thu, Jun 02, 2005 at 01:54:12 +0200,
Havasvölgyi Ottó <[EMAIL PROTECTED]> wrote:
> Thank you Tom.
>
> It was a bit confusing because my WHERE clause looked something like this:
>
> ... WHERE date_field - current_date < '21 days'::interval;
>
> And then I got records, whose with date_field's
rrent_date + '21 days'::interval;
Best Regards,
Otto
- Original Message -
From: "Tom Lane" <[EMAIL PROTECTED]>
To: "Havasvölgyi Ottó" <[EMAIL PROTECTED]>
Cc:
Sent: Tuesday, May 31, 2005 5:46 PM
Subject: Re: [GENERAL] interval integer compari
=?iso-8859-2?Q?Havasv=F6lgyi_Ott=F3?= <[EMAIL PROTECTED]> writes:
> Pg 8.0.3 allows me to compare interval with integer, but I cannot see any
> reasonable rule:
> 1 < '1 days'::interval
The reason that doesn't fail outright is that both integer and
interval have implicit coercions to text. So th
