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.?
