qualified column names

From: Dave Cramer <Dave(at)micro-automation(dot)net>
To: "pgsql-jdbc(at)postgresql(dot)org" <pgsql-jdbc(at)postgresql(dot)org>
Subject: qualified column names
Date: 2003-04-15 13:40:29
Message-ID: 1050414029.1790.414.camel@inspiron.cramers
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general pgsql-hackers pgsql-interfaces pgsql-jdbc

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 <dave(at)fastcrypt(dot)com>
Cramer Consulting
--
Dave Cramer <Dave(at)micro-automation(dot)net>

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2003-04-15 13:43:53 Re: Two 'identical' DB's not acting identically
Previous Message Dave Cramer 2003-04-15 13:40:12 qualified column names

Browse pgsql-hackers by date

  From Date Subject
Next Message Tom Lane 2003-04-15 14:03:19 Re: Are we losing momentum?
Previous Message Dave Cramer 2003-04-15 13:40:12 qualified column names

Browse pgsql-interfaces by date

  From Date Subject
Next Message Tom Lane 2003-04-15 14:17:27 Re: [GENERAL] Problem about pgsql's column alias
Previous Message Dave Cramer 2003-04-15 13:40:12 qualified column names

Browse pgsql-jdbc by date

  From Date Subject
Next Message Tom Lane 2003-04-15 14:17:27 Re: [GENERAL] Problem about pgsql's column alias
Previous Message Dave Cramer 2003-04-15 13:40:12 qualified column names