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

["Ray O'Donnell" <ray@xxxxxxxxxxxx>]

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@xxxxxxxxxxxx