Hi all, I am currently running postgres 8.4.4 and I have the need to override calls to functions that reside in the public schema of my database. For instance in pg_catalog there exists a function
upper(text)
I have a function placed within the public schema that overrides
upper(text)
My question comes down to overriding the call to public.upper(text). That is to say I have to execute the function call like so:
select public.upper(text);
Whereas I want to be able to call public.upper(text) in this manner:
select upper(text);
How does one go about doing this?