| From: | Marek Lewczuk <newsy(at)lewczuk(dot)com> |
|---|---|
| To: | Csaba Nagy <nagy(at)ecircle-ag(dot)com> |
| Cc: | Richard Huxton <dev(at)archonet(dot)com>, 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 10:38:41 |
| Message-ID: | 3FE2D531.1040602@lewczuk.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-bugs 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.
>
>
>
>
| From | Date | Subject | |
|---|---|---|---|
| Next Message | PostgreSQL Bugs List | 2003-12-19 10:56:10 | BUG #1017: Incomplete src/interfaces/libpgtcl/Makefile |
| Previous Message | PostgreSQL Bugs List | 2003-12-19 10:25:58 | BUG #1016: incomplete src/bin/pgtclsh/Makefile |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Greg Sabino Mullane | 2003-12-19 12:07:57 | Re: PostgreSQL speakers needed for OSCON 2004 |
| Previous Message | Csaba Nagy | 2003-12-19 10:22:35 | Re: [GENERAL] CASE in where statement. BUG ?? |