Re: select case problem

From: "Matteo Beccati" <m(dot)beccati(at)crpsoftware(dot)it>
To: <pgsql-sql(at)postgresql(dot)org>
Subject: Re: select case problem
Date: 2002-09-24 14:20:38
Message-ID: 2780D698C269CB4EB303715BA48B6A1033DE@sole.CRP
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

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

In response to

Browse pgsql-sql by date

  From Date Subject
Next Message Roland Roberts 2002-09-24 14:55:41 Re: [SQL] CURRENT_TIMESTAMP
Previous Message Stephan Szabo 2002-09-24 13:51:09 Re: arrays (was untitled)