CSN <cool_screen_name90001@xxxxxxxxx> 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
