Re: interval integer comparison

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 year was 2010. :-o
Now I am using this formula:

... WHERE date_field < current_date + '21 days'::interval;


Best Regards,
Otto



----- Original Message -----
From: "Tom Lane" <tgl@sss.pgh.pa.us>
To: "Havasvölgyi Ottó" <h.otto@freemail.hu>
Cc: <pgsql-general@postgresql.org>
Sent: Tuesday, May 31, 2005 5:46 PM
Subject: Re: [GENERAL] interval integer comparison


> =?iso-8859-2?Q?Havasv=F6lgyi_Ott=F3?= <h.otto@freemail.hu> 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 the only interpretation
> the parser can find is to convert both sides to text and use the text <
> operator.  As text comparisons your answers all make sense.
>
> I've been arguing for a long time that we need to cut down on the number
> of implicit coercions to text...
>
> regards, tom lane
>
> ---------------------------(end of broadcast)---------------------------
> TIP 4: Don't 'kill -9' the postmaster
>
>