From: | Marek Lewczuk <newsy(at)lewczuk(dot)com> |
---|---|
To: | Richard Huxton <dev(at)archonet(dot)com> |
Cc: | Alexander Litvinov <lan(at)ac-sw(dot)com>, Lista dyskusyjna pgsql-general <pgsql-general(at)postgresql(dot)org>, Lista dyskusyjna pgsql-bugs <pgsql-bugs(at)postgresql(dot)org> |
Subject: | Re: [GENERAL] CASE in where statement. BUG ?? |
Date: | 2003-12-19 09:59:43 |
Message-ID: | 3FE2CC0F.2000707@lewczuk.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-bugs 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 ?
From | Date | Subject | |
---|---|---|---|
Next Message | Csaba Nagy | 2003-12-19 10:22:35 | Re: [GENERAL] CASE in where statement. BUG ?? |
Previous Message | Richard Huxton | 2003-12-19 09:42:34 | Re: [GENERAL] CASE in where statement. BUG ?? |
From | Date | Subject | |
---|---|---|---|
Next Message | CoL | 2003-12-19 10:17:44 | Re: How to navigate tree without CONNECT BY? |
Previous Message | Richard Huxton | 2003-12-19 09:42:34 | Re: [GENERAL] CASE in where statement. BUG ?? |