Received: from eclipse.pacifier.com (eclipse.pacifier.com [199.2.117.78]) by hub.org (8.9.3/8.9.3) with ESMTP id KAA38238; Tue, 29 Feb 2000 10:01:52 -0500 (EST) (envelope-from dhogaza@pacifier.com) Received: from desktop (dsl-dhogaza.pacifier.net [216.65.147.68]) by eclipse.pacifier.com (8.9.3/8.9.3pop) with SMTP id HAA05656; Tue, 29 Feb 2000 07:01:38 -0800 (PST) Message-Id: <3.0.1.32.20000229063525.01d06150@mail.pacifier.com> X-Sender: dhogaza@mail.pacifier.com X-Mailer: Windows Eudora Pro Version 3.0.1 (32) Date: Tue, 29 Feb 2000 06:35:25 -0800 To: Thomas Lockhart , Bruce Momjian From: Don Baccus Subject: Re: [HACKERS] Re: [SQL] prob with aggregate and group by - returns multiplesh Cc: Tom Lane , "'pgsql-sql@postgresql.org'" , PostgreSQL Development In-Reply-To: <38BB6BA6.B5FACCAD@alumni.caltech.edu> References: <200002290559.AAA10605@candle.pha.pa.us> Mime-Version: 1.0 Content-Type: text/plain; charset="us-ascii" At 06:48 AM 2/29/00 +0000, Thomas Lockhart wrote: >> > If not, I'd vote for pulling it out. That's a heck of a poor word to >> > reserve. >> I am afraid of lots of user complaints, even if we had not already used >> TEMP. > >OK, but we've already got "user complaints" about TEMP being a >reserved word, so that part seems to balance out. There is apparently >no basis in published standards for TEMP being a reserved word. And >btw it is not currently documented as a reserved word in >syntax.sgml... I vote for the SQL92 TEMPORARY. Let's not add a keyword that is non-standard just because one or another commercial database makes use of it, unless there's some real functionality to be gained that's not covered by the standard. TEMP is covered in SQL92 by TEMPORARY. As an example of when adopting a construct from another commercial database makes sense to me, SEQUENCE and SERIAL are both convenient means of generating unique keys that have no equivalent in the standard. - Don Baccus, Portland OR Nature photos, on-line guides, Pacific Northwest Rare Bird Alert Service and other goodies at http://donb.photo.net.