Received: from oxmail.ox.ac.uk (oxmail2.ox.ac.uk [163.1.2.1]) by hub.org (8.9.3/8.9.3) with ESMTP id EAA98425 for ; Wed, 1 Mar 2000 04:52:13 -0500 (EST) (envelope-from moray.mcconnachie@computing-services.oxford.ac.uk) Received: from ermine.ox.ac.uk ([163.1.2.13]) by oxmail.ox.ac.uk with esmtp (Exim 2.10 #1) id 12Q5jw-0005iw-00; Wed, 1 Mar 2000 09:48:20 +0000 Received: from ermine.ox.ac.uk ([163.1.2.13] helo=moraypc ident=root) by ermine.ox.ac.uk with smtp (Exim 3.13 #1) id 12Q5jw-0000CE-00; Wed, 01 Mar 2000 09:48:20 +0000 Message-ID: <00a801bf8363$4645e550$760e01a3@oucs.ox.ac.uk> From: "Moray McConnachie" To: "Bruce Momjian" Cc: "'pgsql-sql@postgresql.org'" References: <200003010618.BAA18585@candle.pha.pa.us> Subject: Re: [HACKERS] Re: [SQL] prob with aggregate and group by - returns multiplesh Date: Wed, 1 Mar 2000 09:48:18 -0000 Organization: Oxford University MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit X-Priority: 3 X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook Express 5.00.2314.1300 X-MimeOLE: Produced By Microsoft MimeOLE V5.00.2314.1300 ----- Original Message ----- From: Bruce Momjian To: Thomas Lockhart Cc: Tom Lane ; 'pgsql-sql@postgresql.org' ; PostgreSQL Development Sent: Wednesday, March 01, 2000 6:18 AM Subject: Re: [HACKERS] Re: [SQL] prob with aggregate and group by - returns multiplesh > > > So are we willing to field questions from people trying to use TEMP > > > tables and trying TEMP and not TEMPORARY. I realize the restriction on > > > a field called TEMP, but we don't get those very often. How many people > > > are going to guess TEMP and not TEMPORARY? > > > > Well, that's one reason to stick to a published standard. No guessing > > required since one could look it up ;) > > If you survive reading the standard. :-) If you can even *find* the standard :-> (is there an on-line source - all links I've ever seen 404ed...?)