case expression - Mailing list pgsql-general

From Garry Saddington
Subject case expression
Date
Msg-id 200809241633.31519.garry@schoolteachers.co.uk
Whole thread Raw
Responses Re: case expression  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-general
Can anyone tell me why this will not work?

select *,
CASE WHEN postcode ilike '%OO%' THEN ''

END
from addresses
where studentid=1234
and addresstype='C'

There are postcodes like this: OO00 0OO

Regards
Garry

pgsql-general by date:

Previous
From: David Fetter
Date:
Subject: Re: Obfuscated stored procedures (was Re: Oracle and Postgresql)
Next
From: Bruce Momjian
Date:
Subject: Re: Obfuscated stored procedures (was Re: Oracle and Postgresql)