Garry Saddington wrote:
> It does work but returns a column called case. How can I return the case
> column as 'postcode'?
CASE WHEN postcode ilike '%OO%' THEN ''
END as postcode
In response to
pgsql-general by date
|Next:||From: hubert depesz lubaczewski||Date: 2008-09-25 05:35:39|
|Subject: Re: problem with custom_variable_classes|
|Previous:||From: Fernando Moreno||Date: 2008-09-25 01:18:52|
|Subject: Re: case expression|