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@persistent.co.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
>
>
>