qualified column names

From: Dave Cramer <dave(at)fastcrypt(dot)com>
To: psql-interfaces(at)postgresql(dot)org
Cc: PostgreSQL Development <pgsql-hackers(at)postgresql(dot)org>
Subject: qualified column names
Date: 2003-04-15 13:38:46
Message-ID: 1050413925.1743.408.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:12 qualified column names
Previous Message Jay O'Connor 2003-04-15 13:36:51 Appending to an array

Browse pgsql-hackers by date

  From Date Subject
Next Message Dave Cramer 2003-04-15 13:40:12 qualified column names
Previous Message Peter Eisentraut 2003-04-15 13:24:11 Re: [GENERAL] Problem about pgsql's column alias

Browse pgsql-interfaces by date

  From Date Subject
Next Message Dave Cramer 2003-04-15 13:40:12 qualified column names
Previous Message Peter Eisentraut 2003-04-15 13:24:11 Re: [GENERAL] Problem about pgsql's column alias

Browse pgsql-jdbc by date

  From Date Subject
Next Message Dave Cramer 2003-04-15 13:40:12 qualified column names
Previous Message Peter Eisentraut 2003-04-15 13:24:11 Re: [GENERAL] Problem about pgsql's column alias