| From: | Rodger Donaldson <rodgerd(at)diaspora(dot)gen(dot)nz> |
|---|---|
| To: | Roberto Mello <rmello(at)cc(dot)usu(dot)edu> |
| Cc: | pgsql-sql(at)postgresql(dot)org |
| Subject: | Re: to_date has beaten me... |
| Date: | 2003-02-06 09:19:03 |
| Message-ID: | 20030206091902.GA10995@diaspora.gen.nz |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-sql |
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(at)diaspora(dot)gen(dot)nz
I just had this vision of a young boy cowering in terror, whispering:
"I see dumb people"
-- Steve VanDevender
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Christoph Haller | 2003-02-06 09:51:21 | Re: Lock timeout detection in postgres 7.3.1 |
| Previous Message | Roberto Mello | 2003-02-06 05:06:35 | Re: to_date has beaten me... |