Postgres Pro
Downloads
Home   >   mailing lists

Re: optimization issue - Mailing list pgsql-general

From Kenneth Marshall
Subject Re: optimization issue
Date
Msg-id 20210709182743.GG31867@aart.rice.edu
Whole thread Raw
In response to Re: optimization issue  (rob stone <floriparob@gmail.com>)
Responses Re: optimization issue  (rob stone <floriparob@gmail.com>)
List pgsql-general
Tree view 
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

pgsql-general by date:

Previous
From: Jeff Ross
Date:
Subject: Removing a subscription that does not exist
Next
From: Jurrie Overgoor
Date:
Subject: How to debug a connection that's "active" but hanging?