Re: NULL != text ?

CSN <cool_screen_name90001(at)yahoo(dot)com> 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