On Tue, 2007-10-09 at 09:44 +0200, Kaare Rasmussen wrote:
> > In SQL, "=" is both an assignment operator (e.g. UPDATE) and a
> > comparison operator (e.g. WHERE clause). There are nondeterministic
>
>
> Why would that be a problem when they occur in different parts of the
> statement?
>
It can actually be in the same part of the statement:
UPDATE foo SET b = a = 0;
is legal in PostgreSQL. How weird is that? At a glance, can you tell
what it's doing?
Regards,
Jeff Davis