On Wed, Sep 24, 2008 at 3:22 PM, Garry Saddington
<garry@schoolteachers.co.uk> wrote:
>> > select *,
>> > CASE WHEN postcode ilike '%OO%' THEN ''
>> > END
>> > from addresses
> It does work but returns a column called case. How can I return the case
> column as 'postcode'?
You have to give an Alias to this column name
CASE WHEN postcode ilike '%OO%' THEN ''
END AS postcode
--
Regards,
Richard Broersma Jr.
Visit the Los Angeles PostgreSQL Users Group (LAPUG)
http://pugs.postgresql.org/lapug