Received: from sss2.sss.pgh.pa.us (sss.pgh.pa.us [209.114.166.2]) by hub.org (8.9.3/8.9.3) with ESMTP id BAA80869; Wed, 1 Mar 2000 01:30:22 -0500 (EST) (envelope-from tgl@sss.pgh.pa.us) Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss2.sss.pgh.pa.us (8.9.3/8.9.3) with ESMTP id BAA00152; Wed, 1 Mar 2000 01:29:25 -0500 (EST) To: Thomas Lockhart cc: Bruce Momjian , "'pgsql-sql@postgresql.org'" , PostgreSQL Development Subject: Re: [HACKERS] Re: [SQL] prob with aggregate and group by - returns multiplesh In-reply-to: <38BCB55B.AC175BB9@alumni.caltech.edu> References: <200002291719.MAA26261@candle.pha.pa.us> <38BCB55B.AC175BB9@alumni.caltech.edu> Comments: In-reply-to Thomas Lockhart message dated "Wed, 01 Mar 2000 06:14:51 +0000" Date: Wed, 01 Mar 2000 01:29:25 -0500 Message-ID: <149.951892165@sss.pgh.pa.us> From: Tom Lane Thomas Lockhart writes: >> 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 ;) As of an hour ago, neither one is a reserved word ;-) regards, tom lane