Re: If function available?

From: Francisco Reyes <lists(at)natserv(dot)com>
To: Josh Berkus <josh(at)agliodbs(dot)com>
Cc: Pgsql Novice <pgsql-novice(at)postgresql(dot)org>
Subject: Re: If function available?
Date: 2001-11-20 18:15:16
Message-ID: 20011120131016.T75685-100000@zoraida.natserv.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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?

In response to

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message Brett W. McCoy 2001-11-20 18:43:29 Re: If function available?
Previous Message Tom Lane 2001-11-20 17:44:58 Re: 7.1.3 compilation failure (libpq or aync?)