Re: I need a SQL...

You are absoletely correct, quoting the zero did the trick...
And my database has been intialized with Norwegian local, so I am
guessing that that's reason....

Thanks to all fo you... :)

BTJ

On Thu, 2003-09-11 at 16:26, Tom Lane wrote:
> =?ISO-8859-1?Q?Bj=F8rn?= T Johansen <btj(at)havleik(dot)no> writes:
> > Yes, I am sure, I just use copy-and-paste and I have double checked....
> > I am running on 7.3.4 but that shouldn't make any difference?
>
> It'll probably work better if you quote the zero. Unquoted, you get
> some weird textual comparison. Compare:
>
> regression=# explain select * from time_tbl where f1-f1 >= 0;
> QUERY PLAN
> --------------------------------------------------------
> Seq Scan on time_tbl (cost=0.00..1.14 rows=3 width=8)
> Filter: (((f1 - f1))::text >= '0'::text)
> (2 rows)
>
> regression=# explain select * from time_tbl where f1-f1 >= '0';
> QUERY PLAN
> --------------------------------------------------------
> Seq Scan on time_tbl (cost=0.00..1.12 rows=3 width=8)
> Filter: ((f1 - f1) >= '00:00'::interval)
> (2 rows)
>
> In "C" locale, the textual comparison accidentally manages to give
> the desired answers, but in other locales it would not.
>
> (Just another example of why implicit coercions to text are evil.)
>
> regards, tom lane