Postgres 15

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.

CREATE FUNCTION public.test() RETURNS int LANGUAGE SQL RETURN NULL::int;

CREATE FUNCTION

SELECT 'public.test'::regproc::oid

oid

8681686

SELECT 1

CREATE FUNCTION public.test(a int, b int) RETURNS integer LANGUAGE SQL RETURN a + b;

CREATE FUNCTION

SELECT 'public.test'::regproc::oid;

ERROR:  more than one function named "public.test"
LINE 1: SELECT 'public.test'::regproc::oid;
               ^

SELECT 'public.test()'::regprocedure::oid;
SELECT 'public.test(int, int)'::regprocedure::oid;

oid

8681686

SELECT 1

oid

8681687

SELECT 1