Noah Misch wrote: > On Fri, Mar 09, 2018 at 04:55:38PM +0900, Michael Paquier wrote: > > --- a/src/backend/catalog/information_schema.sql > > +++ b/src/backend/catalog/information_schema.sql > > @@ -186,7 +186,7 @@ CREATE FUNCTION _pg_interval_type(typid oid, mod int4) > > RETURNS text > > AS > > $$SELECT > > CASE WHEN $1 IN (1186) /* interval */ > > - THEN upper(substring(format_type($1, $2) from 'interval[()0-9]* > > #"%#"' for '#')) > > + THEN pg_catalog.upper(substring(pg_catalog.format_type($1, $2) > > from 'interval[()0-9]* #"%#"' for '#')) > > ELSE null > > END$$;
> This qualifies some functions, but it leaves plenty of unqualified operators. ... and substring() ... -- Álvaro Herrera https://www.2ndQuadrant.com/ PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services
