Function and Procedure with same signature? - Mailing list pgsql-hackers

From Deepak M
Subject Function and Procedure with same signature?
Date
Msg-id CAMywLyJnJmJCiv8+B4bX4m84Tf1aDgxyh4CAu7cGem=qTtgZzQ@mail.gmail.com
Whole thread Raw
Responses Re: Function and Procedure with same signature?
List pgsql-hackers
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.?

pgsql-hackers by date:

Previous
From: Nathan Bossart
Date:
Subject: Re: glibc qsort() vulnerability
Next
From: Pavel Luzanov
Date:
Subject: Re: Add semi-join pushdown to postgres_fdw