[prev in list] [next in list] [prev in thread] [next in thread] 

List:       postgresql-general
Subject:    Re: [GENERAL] interval integer comparison
From:       Tom Lane <tgl () sss ! pgh ! pa ! us>
Date:       2005-05-31 15:46:14
Message-ID: 12754.1117554374 () sss ! pgh ! pa ! us
[Download RAW message or body]

=?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
[prev in list] [next in list] [prev in thread] [next in thread]