Re: CASE in where statement. BUG ??

Поиск
Список
Период
Сортировка
От Marek Lewczuk
Тема Re: CASE in where statement. BUG ??
Дата
Msg-id 3FE2D531.1040602@lewczuk.com
обсуждение исходный текст
Ответ на Re: CASE in where statement. BUG ??  (Csaba Nagy <nagy@ecircle-ag.com>)
Список pgsql-general
Csaba Nagy wrote:
> Because that's a syntax check, which does NOT evaluate any of the
> expressions, only the types of them. Even if it will not be executed
> ever, it is still wrong, and it should generate an error, because it
> means a mistake on your side which potentially could leave to results
> you didn't expect if executed as is.
> If it would not generate error in these cases, you would scream when you
> by mistake write a wrong query and it doesn't give you the right errors.
> Say thanks to the parser that it catches your errors and doesn't let you
> do detective work to find out why your queries are not working as you
> expect them to work.

Maybe you are right. Thanks.

>
> Cheers,
> Csaba.
>
>
>
>




В списке pgsql-general по дате отправления:

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