title: postgres public schema function aliasing
body: <p>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  </p>
  
  <blockquote>
    <p>upper(text)  </p>
  </blockquote>
  
  <p>I have a function placed within the public schema that overrides   </p>
  
  <blockquote>
    <p>upper(text)  </p>
  </blockquote>
  
  <p>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:  </p>
  
  <blockquote>
    <p>select public.upper(text);  </p>
  </blockquote>
  
  <p>Whereas I want to be able to call public.upper(text) in this manner:  </p>
  
  <blockquote>
    <p>select upper(text);</p>
  </blockquote>
  
  <p>How does one go about doing this?</p>