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.
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? |