field=field [message #22842] |
Fri, 01 November 2002 01:00 |
jann
Messages: 2 Registered: November 2002
|
Junior Member |
|
|
Todd, i think you're wrong in this issue
if value of pointer-field in that table is NULL
then compariasion : pointer=pointer DOES NOT
return TRUE , so , with this clause added
in where statement , it won't updade a row.
>>As far as the ELSE block, a WHERE
>>clause of 'pointer = pointer' is superflous (every >>row would be updated
>>with or without this condition).
|
|
|
Re: field=field [message #22851 is a reply to message #22842] |
Fri, 01 November 2002 09:33 |
Todd Barry
Messages: 4819 Registered: August 2001
|
Senior Member |
|
|
Any equality comparison assumes non-null values. Factoring in NULL values was outside the scope of this question and is a topic unto itself (IS NULL, IS NOT NULL, NVL, etc.).
|
|
|