CASE/WHEN syntax in UPDATE/SET clauses

Robert Koch gms_xy at gmx.de
Fri Oct 17 11:45:43 CEST 2014


CASE/WHEN syntax would be useful for UPDATE/SET clauses. Example:

UPDATE
	tbl1
SET
	col1 = CASE WHEN ... THEN ... ELSE ... END
;

I am not sure if this is conform to ANSI SQL. I would find it useful. Today I have to write multiple UPDATE queries with different WHERE conditions.



More information about the developers-list mailing list