Re: optimization issue

From: rob stone <floriparob(at)gmail(dot)com>
To: Kenneth Marshall <ktm(at)rice(dot)edu>
Cc: Atul Kumar <akumar14871(at)gmail(dot)com>, pgsql-general <pgsql-general(at)lists(dot)postgresql(dot)org>
Subject: Re: optimization issue
Date: 2021-07-10 08:07:43
Message-ID: f98344a300314c1e447fadb1b426d5dc2499f7fb.camel@gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hello Ken,

On Fri, 2021-07-09 at 13:27 -0500, Kenneth Marshall wrote:
> On Fri, Jul 09, 2021 at 01:16:16PM +1000, rob stone wrote:
> > Hello,
> >
> > I am curious.
> >
> > NVL, DECODE and SELECT FROM dual are Oracle methods and these
> > appear in
> > your code.
> >
> > How did you make these work in Postgres? 
> >
> > Cheers,
> > Rob
>
> Hi Rob,
>
> At a guess, they are using the Orafce PostgreSQL extension. It
> provides
> a lot of compatibility functions.
>
> Regards,
> Ken

Thanks. Found it on github.

Regards,
Rob

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Vijaykumar Jain 2021-07-10 08:26:43 Re: How to debug a connection that's "active" but hanging?
Previous Message Phil Endecott 2021-07-09 19:04:55 Why can't I drop a tablespace?