Postgres Pro
Downloads
Home   >   mailing lists

Syntax for "IF" clause in SELECT - Mailing list pgsql-sql

From pgsql@yukonho.de
Subject Syntax for "IF" clause in SELECT
Date
Msg-id 200602090012.52747.pgsql@yukonho.de
Whole thread Raw
Responses Re: Syntax for "IF" clause in SELECT  (Bricklen Anderson <banderson@presinet.com>)
List pgsql-sql
Tree view 
Greetings,

the following is an MySQL statement that I would like to
translate to PostgreSQL:

Could someone point me to a documentation of a coresponding
Systax for an "IF" clause in the a SELECT,
or is the some other way to do this....

select
 if(spektrum is null,' ','J'),
 if(s19 is null,' ','J'),
 if(OhneGrenze is null,' ','J'),
 from namen;


Do I need to create my own function to allow this behaviour!


my best regards,

Stefan
--
email: stefan@yukonho.de
tel  : +49 (0)6232-497631
http://www.yukonho.de

pgsql-sql by date:

Previous
From: Ken Hill
Date:
Subject: Re: Non Matching Records in Two Tables
Next
From: Bricklen Anderson
Date:
Subject: Re: Syntax for "IF" clause in SELECT