Received: from localhost (maia-5.hub.org [200.46.204.182]) by postgresql.org (Postfix) with ESMTP id AAB669FA0EE for ; Tue, 5 Dec 2006 18:59:41 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.182]) (amavisd-new, port 10024) with ESMTP id 24267-06 for ; Tue, 5 Dec 2006 18:59:27 -0400 (AST) X-Greylist: from auto-whitelisted by SQLgrey-1.7.4 Received: from mx3.ipf.is (man.ipf.is [85.197.192.163]) by postgresql.org (Postfix) with ESMTP id 56FC99F931B for ; Tue, 5 Dec 2006 18:59:36 -0400 (AST) Received: (qmail 5292 invoked by uid 1010); 5 Dec 2006 22:53:42 +0000 Received: from 88.149.106.19 by man (envelope-from , uid 1008) with qmail-scanner-1.25-st-qms (clamdscan: 0.88.4/1639. spamassassin: 3.1.4. perlscan: 1.25-st-qms. Clear:RC:1(88.149.106.19):SA:0(-2.5/4.5):. Processed in 4.375487 secs); 05 Dec 2006 22:53:42 -0000 X-Antivirus-HIVE-Mail-From: gnari@hive.is via man X-Antivirus-HIVE: 1.25-st-qms (Clear:RC:1(88.149.106.19):SA:0(-2.5/4.5):. Processed in 4.375487 secs Process 5285) Received: from dsl-149-106-19.hive.is (HELO ?192.168.1.33?) (88.149.106.19) by mx3.ipf.is with SMTP; 5 Dec 2006 22:53:38 +0000 Subject: Re: Using Control Flow Functions in a SELECT Statement From: Ragnar To: Ashish Ahlawat Cc: pgsql-sql@postgresql.org In-Reply-To: <682126990612040842s136366d5wa3461535f93bb544@mail.gmail.com> References: <682126990612040821p88a04d7la2a230901d118921@mail.gmail.com> <45744D85.9050107@presinet.com> <682126990612040842s136366d5wa3461535f93bb544@mail.gmail.com> Content-Type: text/plain; charset=ISO-8859-1 Date: Tue, 05 Dec 2006 23:07:50 +0000 Message-Id: <1165360070.24477.76.camel@localhost.localdomain> Mime-Version: 1.0 X-Mailer: Evolution 2.4.1 Content-Transfer-Encoding: 8bit X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200612/63 X-Sequence-Number: 27019 [ removing a bunch of probably uninterested people from CC ] On mán, 2006-12-04 at 22:12 +0530, Ashish Ahlawat wrote: > Hi Team > > Thanks > > FOR your prompt response....But USING CASE issue still NOT > resolved....Oracle prompts same error. this is a postgresql mailing list, but I believe that even with oracle, the case statement should work. a quick google found http://www.oracle-base.com/articles/9i/Case9i.php gnari