Re: Can we use sql language to create a function in Postgres?

From: Shaozhong SHI <shishaozhong(at)gmail(dot)com>
To: depesz(at)depesz(dot)com
Cc: pgsql-general <pgsql-general(at)lists(dot)postgresql(dot)org>
Subject: Re: Can we use sql language to create a function in Postgres?
Date: 2022-01-05 11:26:49
Message-ID: CA+i5JwbQWQzU29qLuHg_=ieq7CQAhBQUKdzoLQz_tDfaPMfnxQ@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Any online documentation or examples for using Oracle SQL in Postgres?

Regards,

David

On Wed, 5 Jan 2022 at 11:22, Shaozhong SHI <shishaozhong(at)gmail(dot)com> wrote:

> If so, can we use Oracle SQL script in DO block?
>
> Does this mean that all Oracle SQL can be used in Postgres?
>
> Regards,
>
> David
>
> On Wed, 5 Jan 2022 at 11:12, hubert depesz lubaczewski <depesz(at)depesz(dot)com>
> wrote:
>
>> On Wed, Jan 05, 2022 at 11:04:34AM +0000, Shaozhong SHI wrote:
>> > I was given an Oracle script. Can we use sql language to create a
>> function
>> > in Postgres?
>>
>> Sure:
>>
>> create function z() returns int4 language sql as $$
>> select 123;
>> $$;
>>
>> depesz
>>
>

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message hubert depesz lubaczewski 2022-01-05 11:34:26 Re: Can we use sql language to create a function in Postgres?
Previous Message Shaozhong SHI 2022-01-05 11:22:34 Re: Can we use sql language to create a function in Postgres?