Re: CASE in where statement. BUG ??

Поиск
Список
Период
Сортировка
От Marek Lewczuk
Тема Re: CASE in where statement. BUG ??
Дата
Msg-id 3FE2CC0F.2000707@lewczuk.com
обсуждение исходный текст
Ответ на Re: CASE in where statement. BUG ??  (Richard Huxton <dev@archonet.com>)
Ответы 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>)
Список 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 по дате отправления:

Предыдущее
От: Richard Huxton
Дата:
Сообщение: Re: CASE in where statement. BUG ??
Следующее
От: Csaba Nagy
Дата:
Сообщение: Re: CASE in where statement. BUG ??