Re: case expression

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