Re: case expression

From: Guy Rouillier <guyr-ml1(at)burntmail(dot)com>
To: Postgres General List <pgsql-general(at)postgresql(dot)org>
Subject: Re: case expression
Date: 2008-09-25 01:49:57
Message-ID: 48DAEE45.5050908@burntmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Garry Saddington wrote:

> It does work but returns a column called case. How can I return the case
> column as 'postcode'?

select
CASE WHEN postcode ilike '%OO%' THEN ''
END as postcode
from addresses

--
Guy Rouillier

In response to

Browse pgsql-general by date

  From Date Subject
Next Message hubert depesz lubaczewski 2008-09-25 05:35:39 Re: problem with custom_variable_classes
Previous Message Fernando Moreno 2008-09-25 01:18:52 Re: case expression