Re: We aren't a relational database ... ?

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