Re: If function available? - Mailing list pgsql-novice

From Francisco Reyes
Subject Re: If function available?
Date
Msg-id 20011120131016.T75685-100000@zoraida.natserv.net
Whole thread Raw
In response to Re: If function available?  ("Josh Berkus" <josh@agliodbs.com>)
Responses Re: If function available?
List pgsql-novice
On Tue, 20 Nov 2001, Josh Berkus wrote:

> You want CASE, as in:
> CASE WHEN field1 = 1 THEN NULL ELSE field1 END
>
> See Postgresql.org --> Documentation --> SQL Commands --> SELECT for
> more information, or consult your favorite SQL92 manual.

No luck. Neither the online "\h select" or the online docs at the web site
even mention CASE.

Tried searching for an online SQL 92 manual and didn't find any.

Any pointers on how to use the CASE statement or a URL for a general SQL
92 reference?


pgsql-novice by date:

Previous
From: Brian
Date:
Subject: Re: Emergency backup question.
Next
From: "Brett W. McCoy"
Date:
Subject: Re: If function available?