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

From Marek Lewczuk
Subject Re: CASE in where statement. BUG ??
Date
Msg-id 3FE2D531.1040602@lewczuk.com
Whole thread Raw
In response to Re: CASE in where statement. BUG ??  (Csaba Nagy <nagy@ecircle-ag.com>)
List 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 by date:

Previous
From: Csaba Nagy
Date:
Subject: Re: CASE in where statement. BUG ??
Next
From: Melanie Bergeron
Date:
Subject: Re: automatic verifications