Re: optimization issue

From: Kenneth Marshall <ktm(at)rice(dot)edu>
To: rob stone <floriparob(at)gmail(dot)com>
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-09 18:27:43
Message-ID: 20210709182743.GG31867@aart.rice.edu
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Jurrie Overgoor 2021-07-09 18:58:53 How to debug a connection that's "active" but hanging?
Previous Message Jeff Ross 2021-07-09 16:49:46 Removing a subscription that does not exist