X-Original-To: pgsql-interfaces-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.2]) by svr1.postgresql.org (Postfix) with ESMTP id C8363D1CCB2 for ; Sun, 28 Mar 2004 05:12:18 +0000 (GMT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (neptune.hub.org [200.46.204.2]) (amavisd-new, port 10024) with ESMTP id 23099-02 for ; Sun, 28 Mar 2004 01:12:13 -0400 (AST) Received: from mail63.csoft.net (unknown [63.111.22.74]) by svr1.postgresql.org (Postfix) with SMTP id E3526D1C4BC for ; Sun, 28 Mar 2004 01:12:14 -0400 (AST) Received: (qmail 11885 invoked by uid 1112); 28 Mar 2004 05:13:15 -0000 Date: Sun, 28 Mar 2004 00:13:15 -0500 (EST) From: Kris Jurka X-X-Sender: books@leary.csoft.net To: "Preston A. Elder" Cc: Peter Eisentraut , Tom Lane , pgsql-interfaces@postgresql.org Subject: Re: Portable interfaces ... In-Reply-To: <1080412297.23111.147.camel@temple.srealm.net.au> Message-ID: References: <1080012121.10179.56.camel@temple.srealm.net.au> <15657.1080018332@sss.pgh.pa.us> <1080020317.10179.71.camel@temple.srealm.net.au> <200403261122.43740.peter_e@gmx.net> <1080412297.23111.147.camel@temple.srealm.net.au> MIME-Version: 1.0 Content-Type: TEXT/PLAIN; charset=US-ASCII X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200403/36 X-Sequence-Number: 4815 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