Postgres Pro
Downloads
Home   >   mailing lists

Re: Can we use sql language to create a function in Postgres? - Mailing list pgsql-general

From Ray O'Donnell
Subject Re: Can we use sql language to create a function in Postgres?
Date
Msg-id 3716cb3b-21e9-a204-1b2c-37a4f023c72f@rodonnell.ie
Whole thread Raw
In response to Can we use sql language to create a function in Postgres?  (Shaozhong SHI <shishaozhong@gmail.com>)
Responses Re: Can we use sql language to create a function in Postgres?  (Ray O'Donnell <ray@rodonnell.ie>)
List pgsql-general
Tree view 
On 05/01/2022 11:04, Shaozhong SHI wrote:
> I was given an Oracle script.  Can we use sql language to create a 
> function in Postgres?

Yes, absolutely:

create function my_function(...)
as
$$
   select.....
$$
language sql;


Is this what you mean?


Ray.


-- 
Raymond O'Donnell // Galway // Ireland
ray@rodonnell.ie

pgsql-general by date:

Previous
From: Shaozhong SHI
Date:
Subject: Can we use sql language to create a function in Postgres?
Next
From: Ray O'Donnell
Date:
Subject: Re: Can we use sql language to create a function in Postgres?