Re: If function available?

From: "Brett W(dot) McCoy" <bmccoy(at)chapelperilous(dot)net>
To: Francisco Reyes <lists(at)natserv(dot)com>
Cc: Josh Berkus <josh(at)agliodbs(dot)com>, Pgsql Novice <pgsql-novice(at)postgresql(dot)org>
Subject: Re: If function available?
Date: 2001-11-20 18:43:29
Message-ID: Pine.LNX.4.30.0111201343100.15089-100000@chapelperilous.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

On Tue, 20 Nov 2001, Francisco Reyes 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?

http://www.postgresql.org/idocs/index.php?functions-conditional.html

-- Brett
http://www.chapelperilous.net/
------------------------------------------------------------------------
You should emulate your heros, but don't carry it too far. Especially
if they are dead.

In response to

Browse pgsql-novice by date

  From Date Subject
Next Message Juan Jose Natera Abreu 2001-11-20 20:02:58 Re: Info about DBI::Sybase.
Previous Message Francisco Reyes 2001-11-20 18:15:16 Re: If function available?