Postgres Pro
Downloads
Home   >   mailing lists

Re: case expression - Mailing list pgsql-general

From Guy Rouillier
Subject Re: case expression
Date
Msg-id 48DAEE45.5050908@burntmail.com
Whole thread Raw
In response to Re: case expression  (Garry Saddington <garry@schoolteachers.co.uk>)
List pgsql-general
Tree view 
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

pgsql-general by date:

Previous
From: "Fernando Moreno"
Date:
Subject: Re: case expression
Next
From: hubert depesz lubaczewski
Date:
Subject: Re: problem with custom_variable_classes