pg.ddx.io pgsql-interfaces@postgresql.org mailing list archivehelp / color / mirror / Atom feed
qualified column names 4+ messages / 2 participants [nested] [flat]
* qualified column names @ 2003-04-15 13:38 Dave Cramer <dave@fastcrypt.com> 3 siblings, 0 replies; 4+ messages in thread From: Dave Cramer @ 2003-04-15 13:38 UTC (permalink / raw) To: psql-interfaces@postgresql.org; +Cc: PostgreSQL Development <pgsql-hackers@postgresql.org> 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@fastcrypt.com> Cramer Consulting ^ permalink raw reply [nested|flat] 4+ messages in thread
* qualified column names @ 2003-04-15 13:40 Dave Cramer <dave@fastcrypt.com> 3 siblings, 0 replies; 4+ messages in thread From: Dave Cramer @ 2003-04-15 13:40 UTC (permalink / raw) To: pgsql-interfaces 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@fastcrypt.com> Cramer Consulting ^ permalink raw reply [nested|flat] 4+ messages in thread
* qualified column names @ 2003-04-15 13:40 Dave Cramer <Dave@micro-automation.net> 3 siblings, 0 replies; 4+ messages in thread From: Dave Cramer @ 2003-04-15 13:40 UTC (permalink / raw) To: pgsql-jdbc@postgresql.org <pgsql-jdbc@postgresql.org> 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@fastcrypt.com> Cramer Consulting -- Dave Cramer <Dave@micro-automation.net> ^ permalink raw reply [nested|flat] 4+ messages in thread
* qualified column names @ 2003-04-17 15:19 Dave Cramer <dave@fastcrypt.com> 3 siblings, 0 replies; 4+ messages in thread From: Dave Cramer @ 2003-04-17 15:19 UTC (permalink / raw) To: pgsql-interfaces; +Cc: PostgreSQL Development <pgsql-hackers@postgresql.org> 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 <dave@fastcrypt.com> Cramer Consulting ^ permalink raw reply [nested|flat] 4+ messages in thread
end of thread, other threads:[~2003-04-17 15:19 UTC | newest] Thread overview: 4+ messages (download: mbox mbox.gz follow: Atom feed) -- links below jump to the message on this page -- 2003-04-15 13:38 ` Dave Cramer <dave@fastcrypt.com> 2003-04-15 13:40 ` Dave Cramer <dave@fastcrypt.com> 2003-04-15 13:40 ` Dave Cramer <Dave@micro-automation.net> 2003-04-17 15:19 ` Dave Cramer <dave@fastcrypt.com>
This inbox is served by DDX for PostgreSQL; see mirroring instructions for how to clone and mirror all data and code used for this inbox