your select returns no records but if I use
WHERE p.proname ~ 'day_inc'
instead of
WHERE p.proname OPERATOR(pg_catalog.~) '^(pg_catalog.day_inc)$'
Schema
Name
Result data type
Argument data types
Type
pg_catalog
day_inc
anyelement
adate anyelement, ndays numeric
func
pg_catalog
day_inc
anyelement
ndays numeric, adate anyelement
func
--
Sent from: https://www.postgresql-archive.org/PostgreSQL-general-f1843780.html