X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [64.117.224.130]) by svr1.postgresql.org (Postfix) with ESMTP id 91909D1B4F1 for ; Sat, 4 Oct 2003 00:51:04 +0000 (GMT) Received: from svr1.postgresql.org ([64.117.224.193]) by localhost (neptune.hub.org [64.117.224.130]) (amavisd-new, port 10024) with ESMTP id 82303-06 for ; Fri, 3 Oct 2003 21:50:21 -0300 (ADT) Received: from mail.gmx.net (mail.gmx.net [213.165.64.20]) by svr1.postgresql.org (Postfix) with SMTP id 30EA0D1B4E3 for ; Fri, 3 Oct 2003 21:50:17 -0300 (ADT) Received: (qmail 3313 invoked by uid 65534); 4 Oct 2003 00:50:20 -0000 Received: from p3EE05D72.dip.t-dialin.net (EHLO gmx.net) (62.224.93.114) by mail.gmx.net (mp006) with SMTP; 04 Oct 2003 02:50:20 +0200 X-Authenticated: #718964 Message-ID: <3F7E1946.3060604@gmx.net> Date: Sat, 04 Oct 2003 02:50:14 +0200 From: Doris Bernloehr User-Agent: Mozilla/5.0 (X11; U; Linux i686; en-US; rv:1.4) Gecko/20030624 X-Accept-Language: en-us, en MIME-Version: 1.0 To: pgsql-sql@postgresql.org Subject: Re: Regarding decode function References: In-Reply-To: Content-Type: text/plain; charset=us-ascii; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200310/61 X-Sequence-Number: 15461 > Right now I have a query which uses decode function to get data in > Oracle database, I want know is there any alternative function to > decode which can do the decode functionality in Postgresql. Oracle: decode (value, 0, 'zero', 1, 'one', 'unknown') In PostgreSQL you have to use CASE WHEN Syntax: ANSI: CASE WHEN value=0 THEN 'zero' WHEN value=1 THEN 'one' ELSE 'unknown' END or CASE value WHEN 0 THEN 'zero' WHEN 1 THEN 'one' ELSE 'unknown' END Regards Doris