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:
[EMAIL PROTECTED]> set search_path = 'unison';
SET
[EMAIL PROTECTED]> 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.
---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match
