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

On 05/01/2022 11:08, Ray O'Donnell wrote:
> 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;

Should have added the link to the docs:

https://www.postgresql.org/docs/14/server-programming.html

Ray.


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