CASE/WHEN syntax in UPDATE/SET clauses

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

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

	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