X-Original-To: pgsql-sql@postgresql.org Received: from localhost (postgresql.org [64.49.215.8]) by postgresql.org (Postfix) with ESMTP id 33CA0474E42 for ; Thu, 6 Feb 2003 04:19:14 -0500 (EST) Received: from israel.diaspora.gen.nz (israel.diaspora.gen.nz [202.50.109.65]) by postgresql.org (Postfix) with ESMTP id 43FFE474E4F for ; Thu, 6 Feb 2003 04:19:13 -0500 (EST) Received: from rodgerd by israel.diaspora.gen.nz with local (Exim 3.35 #1 (Debian)) id 18giBT-0002rk-00; Thu, 06 Feb 2003 22:19:03 +1300 Date: Thu, 6 Feb 2003 22:19:03 +1300 To: Roberto Mello Cc: pgsql-sql@postgresql.org Subject: Re: to_date has beaten me... Message-ID: <20030206091902.GA10995@diaspora.gen.nz> Reply-To: rodgerd@diaspora.gen.nz References: <20030206040247.GA8032@diaspora.gen.nz> <9133.1044505377@sss.pgh.pa.us> <20030206042539.GA8420@diaspora.gen.nz> <20030206050635.GB19492@cc.usu.edu> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: <20030206050635.GB19492@cc.usu.edu> User-Agent: Mutt/1.3.28i From: Rodger Donaldson X-Virus-Scanned: by AMaViS new-20020517 X-Archive-Number: 200302/108 X-Sequence-Number: 11506 On Wed, Feb 05, 2003 at 10:06:35PM -0700, Roberto Mello wrote: > On Thu, Feb 06, 2003 at 05:25:39PM +1300, Rodger Donaldson wrote: > > > > Why yes. Yes I did. Too much time spent with Oracle, evidently. > > Next I'll be wondering why DECODE doesn't work... > > Because DECODE is non-standard AFAIK. You can use CASE WHEN in PostgreSQL, > which IIRC, started being supported in Oracle 8.1.7. It was a joke. A feeble one, I know. CASE actually turned up in 8.1.6 - I ended up rewriting a chunk of a client's codebase, mostly because DECODE is so illegible next to CASE. -- Rodger Donaldson rodgerd@diaspora.gen.nz I just had this vision of a young boy cowering in terror, whispering: "I see dumb people" -- Steve VanDevender