X-Original-To: pgsql-hackers@postgresql.org Received: from spampd.localdomain (postgresql.org [64.49.215.8]) by postgresql.org (Postfix) with ESMTP id EA2914762BB for ; Thu, 17 Apr 2003 11:19:42 -0400 (EDT) Received: from net2.micro-automation.com (net2.micro-automation.com [64.7.141.29]) by postgresql.org (Postfix) with SMTP id 8775B475FC8 for ; Thu, 17 Apr 2003 11:19:27 -0400 (EDT) Received: (qmail 22244 invoked from network); 17 Apr 2003 15:19:27 -0000 Received: from eboxwest.ebox.com (HELO ?192.168.1.31?) (206.51.23.194) by net2.micro-automation.com with SMTP; 17 Apr 2003 15:19:27 -0000 Subject: qualified column names From: Dave Cramer To: "pgsql-interfaces@postgresql.org" Cc: PostgreSQL Development In-Reply-To: References: Content-Type: text/plain Organization: Cramer Consulting Message-Id: <1050592766.6918.33.camel@inspiron.cramers> Mime-Version: 1.0 X-Mailer: Ximian Evolution 1.2.1 Date: 17 Apr 2003 11:19:26 -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 version=2.50 X-Spam-Level: X-Spam-Checker-Version: SpamAssassin 2.50 (1.173-2003-02-20-exp) X-Archive-Number: 200304/660 X-Sequence-Number: 38150 I didn't get a reply to this, I'm wondering if it just slipped through the cracks? 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