Received: from web20201.mail.yahoo.com (web20201.mail.yahoo.com [216.136.226.56]) by postgresql.org (8.11.3/8.11.4) with SMTP id fAM8DHm93870 for ; Thu, 22 Nov 2001 03:13:17 -0500 (EST) (envelope-from mindterm@yahoo.com) Message-ID: <20011122081318.9611.qmail@web20201.mail.yahoo.com> Received: from [203.85.100.3] by web20201.mail.yahoo.com via HTTP; Thu, 22 Nov 2001 00:13:18 PST Date: Thu, 22 Nov 2001 00:13:18 -0800 (PST) From: MindTerm Subject: Porting Oracle Decode to Postgresql To: pgsql-sql@postgresql.org MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii X-Archive-Number: 200111/309 X-Sequence-Number: 5691 Dear all, I am writing to ask how to port oracle's decode( ..) function to postgresql ? It seems that plpgsql is not a possible way because there are undefined input parameters for decode() function. How about c ? any suggestion ? any existing source ? M.T. __________________________________________________ Do You Yahoo!? Yahoo! GeoCities - quick and easy web site hosting, just $8.95/month. http://geocities.yahoo.com/ps/info1