Re: [GENERAL] Using case expressions in update set clause

2007-10-15 Thread Gregory Stark
"Chris Velevitch" <[EMAIL PROTECTED]> writes: > I just want to clarify that the following will always behave the way I > think it's supposed to behave:- > > update tableA > set date_field = case when date_field is null then some_date > els

[GENERAL] Using case expressions in update set clause

2007-10-14 Thread Chris Velevitch
I just want to clarify that the following will always behave the way I think it's supposed to behave:- update tableA set date_field = case when date_field is null then some_date else date_field end; If the current value of date_field for