X-Original-To: pgsql-interfaces@postgresql.org Received: from spampd.localdomain (postgresql.org [64.49.215.8]) by postgresql.org (Postfix) with ESMTP id E5110474E44 for ; Tue, 15 Apr 2003 09:40:13 -0400 (EDT) Received: from net2.micro-automation.com (net2.micro-automation.com [64.7.141.29]) by postgresql.org (Postfix) with SMTP id F342F47634D for ; Tue, 15 Apr 2003 09:40:11 -0400 (EDT) Received: (qmail 26674 invoked from network); 15 Apr 2003 13:40:15 -0000 Received: from dcdsl.ebox.com (HELO ?192.168.2.100?) (64.7.143.116) by net2.micro-automation.com with SMTP; 15 Apr 2003 13:40:15 -0000 Subject: qualified column names From: Dave Cramer To: "pgsql-interfaces@postgresql.org" In-Reply-To: References: Content-Type: text/plain Organization: Cramer Consulting Message-Id: <1050414011.30093.411.camel@inspiron.cramers> Mime-Version: 1.0 X-Mailer: Ximian Evolution 1.2.1 Date: 15 Apr 2003 09:40:12 -0400 Content-Transfer-Encoding: 7bit X-AntiVirus: scanned for viruses by AMaViS 0.2.1 (http://amavis.org/) X-Spam-Status: No, hits=-21.4 required=5.0 tests=BAYES_10,IN_REP_TO,REFERENCES,TO_ADDRESS_EQ_REAL, USER_AGENT_XIMIAN autolearn=ham version=2.50 X-Spam-Level: X-Spam-Checker-Version: SpamAssassin 2.50 (1.173-2003-02-20-exp) X-Archive-Number: 200304/125 X-Sequence-Number: 4064 jdbc and I suspect odbc have a requirement to return the table, and schema of a column in a result set. for jdbc at least a possible solution is to return schema.table.column for each column returned. This could be turned off/on using GUC variable. functions, and computed fields can just return the column name as they don't belong to a schema or table. Does anyone have any other requirments? -- Dave Cramer Cramer Consulting