---------- Forwarded message ----------
From:
Mirko Pace <mirkop82@gmail.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@ntlworld.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