---------- Forwarded message ---------- From: Mirko Pace <mirko...@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 <dwn...@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
