CSN <[EMAIL PROTECTED]> writes:
> BTW, it (the SQL spec I presume) has always seemed
> contradictory to me that you can't do:
> select * from table where field=null;
> but can do:
> update table set field=null;
This only seems contradictory if you fail to make the distinction
between "=" used as a comparison operator and "=" used to mean
assignment.
Personally I prefer programming languages that actually spell the
two concepts differently ... but enough don't that one has to learn
to live with it.
regards, tom lane
---------------------------(end of broadcast)---------------------------
TIP 2: Don't 'kill -9' the postmaster
