Re: UPDATE statement with syntax error doesn't raise a warning?

---------- Forwarded message ----------
From: Mirko Pace <mirkop82(at)gmail(dot)com>
Date: Mon, Sep 28, 2009 at 2:59 PM
Subject: Re: [GENERAL] UPDATE statement with syntax error doesn't raise a
warning?
To: David W Noon <dwnoon(at)ntlworld(dot)com>

> I presume you meant "nothing" rather than "anything".
>

sorry for my poor english :/

> SET boolean_field = (true AND my_notes = 'something')
>
> As you can see, this is a valid Boolean expression. There is no syntax
> error. It just doesn't mean what you wanted.
>

uhm... I forgot to specify:
PostgreSQL 8.3.8 on i686-pc-linux-gnu, compiled by GCC gcc (Debian
4.3.2-1.1) 4.3.2
psql 8.3.8 (Ubuntu package)
_AND_
Mirko 0.01alpha

thank you all for being so patient with me.

Have a nice day!

Mirko