Re: AW: [HACKERS] Proposed Changes to PostgreSQL - Mailing list pgsql-hackers

From Chris Bitmead
Subject Re: AW: [HACKERS] Proposed Changes to PostgreSQL
Date
Msg-id 389A05A4.566417B4@nimrod.itg.telecom.com.au
Whole thread Raw
In response to AW: [HACKERS] Proposed Changes to PostgreSQL  (Zeugswetter Andreas SB <ZeugswetterA@wien.spardat.at>)
List pgsql-hackers
Zeugswetter Andreas SB wrote:

> > Also there should be an settable option that specifies that "*" should
> > also return the normally ignored columns of oid and classname. This is
> > so that OO programs that embed SQL into them also get back the oid and
> > classname which are required for the behind the scenes implementation
> > of an ODMG client. Something like...
> 
> why don't they simply always
> select oid, classname, * from ...
> The reason I suggest this is, because implementing joins to return the
> correct oid, classname seems very complex.

Because I envisage people using an ODBMS-ish interface and allowing
use of SQL queries. This infrastructure wouldn't work without oid and 
classname. Forcing always to add oid, classname would be
repetitive and error prone.


pgsql-hackers by date:

Previous
From: Chris Bitmead
Date:
Subject: Re: [HACKERS] Re: [SQL] Proposed Changes to PostgreSQL
Next
From: Hannu Krosing
Date:
Subject: Re: [HACKERS] Re: [SQL] Proposed Changes to PostgreSQL