How do you use the editor for the database functions?

There doesn't seem to be up to date documentation describing how to use the interface portion of the database functions. What are we expected to write in the definition?

Is it the full:

create function hello_world()
returns text
language plpgsql
security definer set search_path = public
as $$
begin
  select 'hello world';
end;
$$;

create function hello_world()
returns text
language plpgsql
security definer set search_path = public
as $$
begin
  select 'hello world';
end;
$$;

create function hello_world()
returns text
language plpgsql
security definer set search_path = public
as $$
begin
  select 'hello world';
end;
$$;

create function hello_world()
returns text
language plpgsql
security definer set search_path = public
as $$
begin
  select 'hello world';
end;
$$;

and if so what's the relationship between the parameters defined above via GUI and what we write in the function?

How do you use the editor for the database functions?

Similar Threads

Similar Threads

Similar Threads