| From: | KÖPFERL Robert <robert(dot)koepferl(at)sonorys(dot)at> |
|---|---|
| To: | pgsql-sql(at)postgresql(dot)org |
| Subject: | Generic Join on Arrays |
| Date: | 2005-05-30 13:42:49 |
| Message-ID: | ED4E30DD9C43D5118DFB00508BBBA76EB16721@neptun.sonorys.at |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-sql |
Hi,
I'm currently on retrieving meta infromation about db-schemas.
As I found out, pg_proc relation provides me with data about defined stored
procedures. Togehter with other relations as pg_type I can retrieve readable
information, like:
select proname, pd.description FROM pg_proc pp left outer join
pg_description pd on pp.oid=pd.objoid
BUT, how about arrays of type "oidvector" (int4-array) containing foreign
keys (to be joined) as pg_proc's column "proargtypes"
Is there a way to make some kind of indetermine number of JOINs on the
single array items?
I want to retrieve a list of argument type names, not plain numbers.
I want to avoid doing several resolutions oid->name
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Michael Fuhr | 2005-05-30 14:08:57 | Re: Generic Join on Arrays |
| Previous Message | Jay Sheehan | 2005-05-30 03:23:28 | Re: [4] |