Re: case expression

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