Received: from localhost (IDENT:root@hectic-1.jpl.nasa.gov [128.149.68.203]) by hub.org (8.9.3/8.9.3) with ESMTP id JAA23345; Tue, 29 Feb 2000 09:30:49 -0500 (EST) (envelope-from lockhart@alumni.caltech.edu) Received: from alumni.caltech.edu (lockhart@localhost [127.0.0.1]) by localhost (8.8.7/8.8.7) with ESMTP id OAA11757; Tue, 29 Feb 2000 14:35:08 GMT Sender: lockhart@hub.org Message-ID: <38BBD91C.E11F7547@alumni.caltech.edu> Date: Tue, 29 Feb 2000 14:35:08 +0000 From: Thomas Lockhart X-Mailer: Mozilla 4.6 [en] (X11; I; Linux 2.0.36 i686) X-Accept-Language: en MIME-Version: 1.0 To: Peter Eisentraut CC: Tom Lane , George Dau , "'pgsql-sql@postgresql.org'" , PostgreSQL Development Subject: Re: [HACKERS] Re: [SQL] prob with aggregate and group by - returnsmultiples References: Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit > > A major release is a good time to adjust syntax to promote > > compliance... > I've been (lightly) bashed in the past for proposing such things (see > END/ABORT) but I'm with you. I think that TEMP may be far too wide-spread > by now, though. Well, imho the TEMP issue is not identical to END/ABORT. For TEMP, we are unnecessarily restricting the space of possible identifiers, eliminating a common and obvious name. The fix is trivial, and the affected parties are *only* those who use temporary tables and who chose to *not* use SQL92 syntax, which was always available. - Thomas -- Thomas Lockhart lockhart@alumni.caltech.edu South Pasadena, California