Re: case expression - Mailing list pgsql-general

From Garry Saddington
Subject Re: case expression
Date
Msg-id 200809242322.16779.garry@schoolteachers.co.uk
Whole thread Raw
In response to Re: case expression  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: case expression  ("Richard Broersma" <richard.broersma@gmail.com>)
Re: case expression  (Guy Rouillier <guyr-ml1@burntmail.com>)
List pgsql-general
On Wednesday 24 September 2008 21:03, Tom Lane wrote:
> Garry Saddington <garry@schoolteachers.co.uk> writes:
> > Can anyone tell me why this will not work?
> >
> > select *,
> > CASE WHEN postcode ilike '%OO%' THEN ''
> > END
> > from addresses
> > ...
>
> Define "not work".  What are you expecting it to do versus what
> really happens?
>
> Right offhand it looks like the CASE will return either an empty
> string or a NULL, which doesn't seem particularly useful ...
>
>             regards, tom lane
It does work but returns a column called case. How can I return the case
column as 'postcode'?

Regards
garry

pgsql-general by date:

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