Re: Dealing with table names in functions

[Reece Hart <reece(at)harts(dot)net>]

On Thu, 2007-03-22 at 09:40 -0400, Alvaro Herrera wrote:
> Pass the optionally qualified name and cast it to regclass.  It will
> work correctly when the name is not qualified, applying search_path,
> and it will also work when the name is qualified. 

Is there a way to get names that are always qualified, irrespective of
the search_path? Once one has the oid, it's an easy function to write,
but I suspect this machinery already exists.

For example, I'd like the hypothetical cast:
        rkh(at)csb-dev=> set search_path = 'unison';
        SET
        
        rkh(at)csb-dev=> select 'pseq'::regclass::oid::FQregclass;
         regclass 
        ----------
         unison.pseq
        (1 row)


-Reece

-- 
Reece Hart, http://harts.net/reece/, GPG:0x25EC91A0
./universe -G 6.672e-11 -e 1.602e-19 -protonmass 1.673e-27 -uspres bush
kernel warning: universe consuming too many resources. Killing.
universe killed due to catastrophic leadership. Try -uspres carter.