From: | Zeugswetter Andreas SB <ZeugswetterA(at)wien(dot)spardat(dot)at> |
---|---|
To: | "'chris(at)bitmead(dot)com'" <chris(at)bitmead(dot)com>, "'pgsql-hackers(at)postgreSQL(dot)org'" <pgsql-hackers(at)postgreSQL(dot)org> |
Subject: | AW: [HACKERS] Proposed Changes to PostgreSQL |
Date: | 2000-02-03 14:47:07 |
Message-ID: | 219F68D65015D011A8E000006F8590C603FDC238@sdexcsrv1.f000.d0188.sd.spardat.at |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
> The SQL style is to use wordy descriptions of the operators
> meaning. "ONLY" fits well here because it describes its own meaning
> perfectly whereas to the unitiated, "*" is harder to guess at. While
> this change is an incompatibility I hope for those few people using
> inheritance they can accept the need to move forward without
> over-burden of backwards compatibility.
Might also allow the *, but do nothing with it, or maybe throw a
"deprecated" notice.
> > SELECT *, studentid FROM person;
> NAME
> ----
> Fred
> Bill
>
> NAME | STUDENTID
> ----------------
> Jim | 23455
> Chris| 45666
The above is incorrect, since the * already returns studentid, thus the
result
of the above query should be:
> SELECT *, studentid FROM person;
NAME
----
Fred
Bill
NAME | STUDENTID | FACULTY | STUDENTID
--------------------------
Jim | 23455 | Science | 23455
Chris| 45666 | Arts | 45666
> 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.
The rest sounds good to me :-)
Andreas
From | Date | Subject | |
---|---|---|---|
Next Message | Oliver Elphick | 2000-02-03 15:06:42 | Re: [HACKERS] Recent RI changes have broken something |
Previous Message | Mark Hollomon | 2000-02-03 13:40:24 | Re: [HACKERS] Re: [SQL] Proposed Changes to PostgreSQL |