On 26/06/11 16:44, Michael Nolan wrote:
> Earlier today I was working on a MySQL database (not by choice, I
> assure you),
> and I typed a statement like this:
>
> Update tablexyz set field1 = '15' where field2 - 20;
>
> The '-' was supposed to be an equal sign, but MySQL executed it
> anyway. (Field2 is an integer.)
>
> I was not amused.
>
> PostgreSQL reports this as an error, of course.
> --
> Mike Nolan
> nolan(at)tssi(dot)com <mailto:nolan(at)tssi(dot)com>
I am guessing that '(field2 - 20)' is evaluated, and if non-zero it is
treated as true?