| From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
|---|---|
| To: | Oliver Jowett <oliver(at)opencloud(dot)com> |
| Cc: | Kris Jurka <books(at)ejurka(dot)com>, Johann Robette <jrobette(at)onyme(dot)com>, pgsql-jdbc(at)postgresql(dot)org |
| Subject: | Re: Postgres 8.0 + JDBC |
| Date: | 2004-10-05 21:28:12 |
| Message-ID: | 18241.1097011692@sss.pgh.pa.us |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general pgsql-jdbc |
Oliver Jowett <oliver(at)opencloud(dot)com> writes:
> I am wondering if the right way to find the array OID is to prepend "_"
> and search on pg_type.typname, or to look for pg_type.typinput = (oid of
> array_in) and pg_type.typelem = (oid of underlying type). Is there a
> 'standard' way of finding an array type OID?
The backend does it by name, ie prepend '_' and lookup by typname (and
typnamespace). This is a mite unclean but it hasn't seemed worth
fixing. If you like you can use the typelem as an additional check that
you found the right thing.
regards, tom lane
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Vivek Khera | 2004-10-05 21:28:44 | Re: Random not so random |
| Previous Message | Joshua D. Drake | 2004-10-05 21:13:11 | Re: SSL connection between PHP4 & PostgreSQL ??? |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Euler Taveira de Oliveira | 2004-10-06 03:59:20 | errors.properties fixes and translation update |
| Previous Message | Oliver Jowett | 2004-10-05 20:57:15 | Re: Postgres 8.0 + JDBC |