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.