Garry Saddington <garry@schoolteachers.co.uk> writes:
> Can anyone tell me why this will not work?
> select *,
> CASE WHEN postcode ilike '%OO%' THEN ''
> END
> from addresses
> ...
Define "not work". What are you expecting it to do versus what
really happens?
Right offhand it looks like the CASE will return either an empty
string or a NULL, which doesn't seem particularly useful ...
regards, tom lane