Re: CASE in where statement. BUG ?? - Mailing list pgsql-general

From Marek Lewczuk
Subject Re: CASE in where statement. BUG ??
Date
Msg-id 3FE2CC0F.2000707@lewczuk.com
Whole thread Raw
In response to Re: CASE in where statement. BUG ??  (Richard Huxton <dev@archonet.com>)
Responses Re: CASE in where statement. BUG ??  (Csaba Nagy <nagy@ecircle-ag.com>)
Re: CASE in where statement. BUG ??  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-general
Richard Huxton wrote:
> On Friday 19 December 2003 09:02, Marek Lewczuk wrote:
>
> But until it's evaluated ''<>'' it doesn't know it is false. When building the
> CASE expression, it's trying to map types to each elements and notes that ''
> is not an int. Only after this stage will it actually try to evaluate the
> expression.
>

Well, I must say that it is wird action... Why to check both elements of
CASE expression, if we know for sure that only one will be executed ?



pgsql-general by date:

Previous
From: Richard Huxton
Date:
Subject: Re: CASE in where statement. BUG ??
Next
From: Csaba Nagy
Date:
Subject: Re: CASE in where statement. BUG ??