Horton

Re: optimization issue

ktm@rice.edu <ktm@rice.edu>

View thread View on postgr.es
From: Kenneth Marshall <ktm@rice.edu>
To: rob stone <floriparob@gmail.com>
Cc: Atul Kumar <akumar14871@gmail.com>, pgsql-general <pgsql-general@lists.postgresql.org>
Date: 2021-07-09T18:27:43Z
Lists: pgsql-general 
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