Re: [INTERFACES] Group/Order by not in target - Was [NEW ODBC DRIVER]

From: "Jose' Soares Da Silva" <sferac(at)bo(dot)nettuno(dot)it>
To: David Hartwig <daveh(at)insightdist(dot)com>
Cc: Chris Osborn <fozztexx(at)talia(dot)hq(dot)vxn(dot)com>, pgsql-hackers <pgsql-hackers(at)postgreSQL(dot)org>, pgsql-interfaces <pgsql-interfaces(at)postgreSQL(dot)org>
Subject: Re: [INTERFACES] Group/Order by not in target - Was [NEW ODBC DRIVER]
Date: 1998-05-15 13:34:04
Message-ID: Pine.LNX.3.96.980515132342.570A-100000@proxy.bazzanese.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers pgsql-interfaces

On Mon, 11 May 1998, David Hartwig wrote:


> It is not very difficult to produce this problem in MS Access 97; I
> expect my users to beat me up pretty good on this issue. Thus, I plan to
> look into making the fix in the backend myself. Conceptually it does not
> seem too difficult.
>
> 1. Add a hidden attribute to the target node structure.
>
> 2. Modify the parser/analyzer to add any attributes in the GROUP/ORDER BY
> clause that are missing from the target list, to the target list with the
> hidden attribute set.
This would be a great enhancement!
SQL92 specifies that columns in the ORDER BY must appear in the
SELECT clause, but this limitation has no sense, indeed many databases
already implement this enhancement.
Go for it!

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Oleg Broytmann 1998-05-15 13:43:07 Re: [HACKERS] Re: [PATCHES] char/varchar locale support
Previous Message Thomas G. Lockhart 1998-05-15 13:18:13 Re: [PATCHES] char/varchar locale support

Browse pgsql-interfaces by date

  From Date Subject
Next Message Bruce Momjian 1998-05-15 13:51:07 Re: [HACKERS] Re: [INTERFACES] Group/Order by not in target - Was [NEW ODBC DRIVER]
Previous Message Aldrin L. 1998-05-15 06:32:24 mSQL Compatibility Library (fwd)