Request for qualified column names - Mailing list pgsql-hackers

From Dave Cramer
Subject Request for qualified column names
Date
Msg-id 1043629288.21696.185.camel@inspiron.cramers
Whole thread Raw
In response to Re: Can we revisit the thought of PostgreSQL 7.2.4?  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: Request for qualified column names  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-hackers
-- 
Dave Cramer <dave@fastcrypt.com>
Cramer Consulting

This is useful for some O/R tools. The JDBC spec has a getTableName method for each column in a result set.

One issue which will come up is what to do with aggregate, and computed values. For now, we could return null

So for a "select a, b, a+b as sum from c" returns c.a, c.b, ?table?.sum

Dave



pgsql-hackers by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: Windows Build System
Next
From: Tatsuo Ishii
Date:
Subject: Re: Sorting Chinese data in Postgresql 7.3.1