Received: from mta1-rme.xtra.co.nz (mta1-rme.xtra.co.nz [203.96.92.1]) by hub.org (8.9.3/8.9.3) with ESMTP id XAA70460; Tue, 29 Feb 2000 23:17:02 -0500 (EST) (envelope-from csawtell@xtra.co.nz) Received: from berty.localnet ([210.55.86.67]) by mta1-rme.xtra.co.nz (InterMail v4.01.01.00 201-229-111) with ESMTP id <20000301041626.PPMW13182477.mta1-rme@berty.localnet>; Wed, 1 Mar 2000 17:16:26 +1300 Received: from berty (berty.localnet [192.168.1.1]) by berty.localnet (Postfix) with SMTP id 28AB55E68; Wed, 1 Mar 2000 16:29:59 +1300 (NZDT) From: Christopher Sawtell Organization: iOpen Technologies Ltd. To: Tom Lane , Don Baccus Subject: Re: [HACKERS] Re: [SQL] prob with aggregate and group by - returns multiplesh Date: Wed, 1 Mar 2000 16:26:24 +1300 X-Mailer: KMail [version 1.0.17] Content-Type: text/plain Cc: Thomas Lockhart , Bruce Momjian , "'pgsql-sql@postgresql.org'" , PostgreSQL Development References: <29204.951840577@sss.pgh.pa.us> MIME-Version: 1.0 Message-Id: <00030116295801.01591@berty> Content-Transfer-Encoding: 8bit X-KMail-Mark: On Wed, 01 Mar 2000, Tom Lane wrote: > Don Baccus writes: > > 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, > > You're missing the point: we are not talking about *adding* a keyword, > we're talking about *removing* one that we've already supported for > a year or so. That changes matters considerably, IMHO. > > I have in fact been able to make a conflict-free grammar in which TEMP > is accepted but not reserved. It requires a certain amount of > redundancy in the productions (see below), but I think this is a > worthwhile tradeoff for not breaking existing user code. > > Shall I commit this? Is there not also the possibility of making this a configure-time option? ./configure --temporary-table=TEMPORARY # or TEMP as you wish Default to TEMPORARY in accord with SQL 92. -- Sincerely etc., NAME Christopher Sawtell - Support Engineer - iOpen Technologies Ltd. CELL PHONE 021 257 4451 ICQ UIN 45863470 EMAIL chris @ iopen . co . nz, csawtell @ xtra . co . nz CNOTES ftp://ftp.funet.fi/pub/languages/C/tutorials/sawtell_C.tar.gz ---->>> Please refrain from using HTML attachments in e-mails to me. <<<----