From: Bruce Momjian <maillist@candle.pha.pa.us>
To: sferac@bo.nettuno.it
Cc: hackers@postgreSQL.org
Subject: Re: [HACKERS] Re: [INTERFACES] Group/Order by not in target - Was [NEW ODBC DRIVER]
Date: Fri, 15 May 1998 09:51:07 -0400 (EDT)
Message-ID: <199805151351.JAA10949@candle.pha.pa.us> (raw)
In-Reply-To: <Pine.LNX.3.96.980515132342.570A-100000@proxy.bazzanese.com>
>
> 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!
There already is code in the backend for Junk fields to be removed. Not
sure what it does, though.
--
Bruce Momjian | 830 Blythe Avenue
maillist@candle.pha.pa.us | Drexel Hill, Pennsylvania 19026
+ If your life is a hard drive, | (610) 353-9879(w)
+ Christ can be your backup. | (610) 853-3000(h)
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-interfaces@postgresql.org
Cc: maillist@candle.pha.pa.us, sferac@bo.nettuno.it, hackers@postgreSQL.org
Subject: Re: [HACKERS] Re: [INTERFACES] Group/Order by not in target - Was [NEW ODBC DRIVER]
In-Reply-To: <199805151351.JAA10949@candle.pha.pa.us>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
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