qualified column names

From: Dave Cramer <dave(at)fastcrypt(dot)com>
To: "pgsql-interfaces(at)postgresql(dot)org" <pgsql-interfaces(at)postgresql(dot)org>
Subject: qualified column names
Date: 2003-04-15 13:40:12
Message-ID: 1050414011.30093.411.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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Dave Cramer 2003-04-15 13:40:29 qualified column names
Previous Message Dave Cramer 2003-04-15 13:38:46 qualified column names

Browse pgsql-hackers by date

  From Date Subject
Next Message Dave Cramer 2003-04-15 13:40:29 qualified column names
Previous Message Dave Cramer 2003-04-15 13:38:46 qualified column names

Browse pgsql-interfaces by date

  From Date Subject
Next Message Dave Cramer 2003-04-15 13:40:29 qualified column names
Previous Message Dave Cramer 2003-04-15 13:38:46 qualified column names

Browse pgsql-jdbc by date

  From Date Subject
Next Message Dave Cramer 2003-04-15 13:40:29 qualified column names
Previous Message Dave Cramer 2003-04-15 13:38:46 qualified column names