| From: | Kris Jurka <books(at)ejurka(dot)com> |
|---|---|
| To: | "Preston A(dot) Elder" <prez(at)neuromancy(dot)net> |
| Cc: | Peter Eisentraut <peter_e(at)gmx(dot)net>, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, pgsql-interfaces(at)postgresql(dot)org |
| Subject: | Re: Portable interfaces ... |
| Date: | 2004-03-28 05:13:15 |
| Message-ID: | Pine.BSO.4.56.0403280010510.25417@leary.csoft.net |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-interfaces |
On Sat, 27 Mar 2004, Preston A. Elder wrote:
> For example, there is nowhere in the docs that tells me "To get the OID
> of column 'y' in table 'x', do:
> SELECT atttypid FROM pg_attribute
> WHERE attrelid = (SELECT relfilenode FROM pg_class
> WHERE relname = 'x')
> AND attname = 'y'
> ". That would be an extremely useful statement to have in the docs.
This is not correct, you want
"... attrelid = (SELECT oid FROM pg_class ..."
not relfilenode.
Kris Jurka
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Stergios Zissakis | 2004-03-29 13:13:22 | ECPG mass retrieval? |
| Previous Message | Preston A. Elder | 2004-03-27 18:31:37 | Re: Portable interfaces ... |