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