Postgres Pro
Downloads
Home   >   mailing lists

Re: select case problem - Mailing list pgsql-sql

From Matteo Beccati
Subject Re: select case problem
Date
Msg-id 2780D698C269CB4EB303715BA48B6A1033DE@sole.CRP
Whole thread Raw
In response to select case problem  (Joseph Syjuco <joseph@asti.dost.gov.ph>)
List pgsql-sql
Tree view 
Hi,

select case when division_no is null then 'no division' else 'with
division' end from employee;

Is the right syntax

Regards
--
Matteo Beccati
http://www.phpadsnew.com
http://phppgads.sourceforge.net

pgsql-sql by date:

Previous
From: Joseph Syjuco
Date:
Subject: select case problem
Next
From: Roland Roberts
Date:
Subject: Re: [GENERAL] CURRENT_TIMESTAMP