X-Original-To: pgsql-hackers@postgresql.org Received: from spampd.localdomain (postgresql.org [64.49.215.8]) by postgresql.org (Postfix) with ESMTP id 3BB5147631A for ; Tue, 15 Apr 2003 09:38:48 -0400 (EDT) Received: from net2.micro-automation.com (net2.micro-automation.com [64.7.141.29]) by postgresql.org (Postfix) with SMTP id 539FB474E44 for ; Tue, 15 Apr 2003 09:38:46 -0400 (EDT) Received: (qmail 25886 invoked from network); 15 Apr 2003 13:38:49 -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:38:49 -0000 Subject: qualified column names From: Dave Cramer To: psql-interfaces@postgresql.org Cc: PostgreSQL Development In-Reply-To: References: Content-Type: text/plain Organization: Cramer Consulting Message-Id: <1050413925.1743.408.camel@inspiron.cramers> Mime-Version: 1.0 X-Mailer: Ximian Evolution 1.2.1 Date: 15 Apr 2003 09:38:46 -0400 Content-Transfer-Encoding: 7bit X-AntiVirus: scanned for viruses by AMaViS 0.2.1 (http://amavis.org/) X-Spam-Status: No, hits=-21.8 required=5.0 tests=BAYES_10,IN_REP_TO,REFERENCES,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/494 X-Sequence-Number: 37984 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