BEGIN; CREATE EXTENSION IF NOT EXISTS anon CASCADE; NOTICE: installing required extension "pgcrypto" SELECT anon.get_function_schema(NULL::TEXT) IS NULL; ?column? ---------- t (1 row) SELECT anon.get_function_schema('a()') = ''; ?column? ---------- t (1 row) SELECT anon.get_function_schema('a(1,2,3)') = ''; ?column? ---------- t (1 row) SELECT anon.get_function_schema('"A"(1,2,3)') = ''; ?column? ---------- t (1 row) SELECT anon.get_function_schema('a.b()') = 'a'; ?column? ---------- t (1 row) SELECT anon.get_function_schema('a."b.c"(''c.d'')') = 'a'; ?column? ---------- t (1 row) SELECT anon.get_function_schema('"A.B".c()') = 'A.B'; ?column? ---------- t (1 row) SELECT anon.get_function_schema('"A.B"."c.d"()') = 'A.B'; ?column? ---------- t (1 row) SELECT anon.get_function_schema('"a("(1,2,3)') = ''; ?column? ---------- t (1 row) SELECT anon.get_function_schema('"(a)"."B(1)"(1,2,3)') = '(a)'; ?column? ---------- t (1 row) SELECT anon.get_function_schema('"..".".."($$..$$)') = '..'; ?column? ---------- t (1 row) SELECT anon.get_function_schema('".......".a()') = '.......'; ?column? ---------- t (1 row) SELECT anon.get_function_schema('a."......."()') = 'a'; ?column? ---------- t (1 row) SAVEPOINT function_call_error_1; SELECT anon.get_function_schema('a'); ERROR: 'a' is not a valid function call ROLLBACK TO function_call_error_1; ROLLBACK;