From: Rodger Donaldson <rodgerd@diaspora.gen.nz>
To: Roberto Mello <rmello@cc.usu.edu>
Cc: pgsql-sql@postgresql.org
Subject: Re: to_date has beaten me...
Date: Thu, 6 Feb 2003 22:19:03 +1300
Message-ID: <20030206091902.GA10995@diaspora.gen.nz> (raw)
In-Reply-To: <20030206050635.GB19492@cc.usu.edu>
References: <20030206040247.GA8032@diaspora.gen.nz>
<9133.1044505377@sss.pgh.pa.us>
<20030206042539.GA8420@diaspora.gen.nz>
<20030206050635.GB19492@cc.usu.edu>
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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: rodgerd@diaspora.gen.nz, rmello@cc.usu.edu
Subject: Re: to_date has beaten me...
In-Reply-To: <20030206091902.GA10995@diaspora.gen.nz>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox