Re: Updates with NULL

It's just an assignment statement, how ELSE would you assign a value,
even a NULL, to a field?

Manfred Koizar wrote:

>On Mon, 15 Sep 2003 19:34:48 +0530, "Shridhar Daithankar"
><shridhar_daithankar(at)persistent(dot)co(dot)in> wrote:
>
>
>>Update foo set somefield=NULL where somefield >9;
>>
>>Now I am not sure having something equalled with NULL is a good thig logically.
>>
>>
>
>It doesn't matter whether I agree. The standard does not. SQL92 says
>
> <set clause> ::=
> <object column> <equals operator> <update source>
>
> <equals operator> ::= =
>
> <update source> ::=
> <value expression>
> | <null specification>
> | DEFAULT
>
> <null specification> ::=
> NULL
>
>SQL99 is much more verbose and difficult to read, but it is very clear
>that the assignment operator in a set clause has to be "=".
>
>Servus
> Manfred
>
>---------------------------(end of broadcast)---------------------------
>TIP 4: Don't 'kill -9' the postmaster
>
>
>