Hello Hackers,
Folks, When tried to create a function with the same signature as procedure it fails.
postgres=# create or replace procedure obj1(char) language plpgsql as $$ begin select $1; end; $$;
CREATE PROCEDURE
postgres=# create or replace function obj1(char) returns void language sql as $$ select $1 $$;
ERROR: cannot change routine kind
DETAIL: "obj1" is a procedure.
any reason for failures?
Can procedure or function can be defined with the same signature i.e. name and IN arguments ?
as callable for both is different.?