Skip site navigation (1) Skip section navigation (2)

Re: [HACKERS] Re: [SQL] prob with aggregate and group by - returns multiples

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Thomas Lockhart <lockhart(at)alumni(dot)caltech(dot)edu>
Cc: "'pgsql-sql(at)postgresql(dot)org'" <pgsql-sql(at)postgresql(dot)org>, PostgreSQL Development <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: [HACKERS] Re: [SQL] prob with aggregate and group by - returns multiples
Date: 2000-02-29 05:44:22
Message-ID: 27957.951803062@sss.pgh.pa.us (view raw or flat)
Thread:
Lists: pgsql-hackerspgsql-sql
Thomas Lockhart <lockhart(at)alumni(dot)caltech(dot)edu> writes:
>> This is really an unfortunate case where someone should have read the SQL
>> standard before putting in a feature. The SQL keyword is TEMPORARY, and
>> TEMP is really a popular name for a dummy table.

> So why not yank TEMP and require TEMPORARY?

Probably we ought to stop to ask why TEMP is in there to begin with;
perhaps for compatibility with some other RDBMS?

If not, I'd vote for pulling it out.  That's a heck of a poor word to
reserve.

			regards, tom lane

In response to

Responses

pgsql-hackers by date

Next:From: Thomas LockhartDate: 2000-02-29 05:48:12
Subject: Re: [HACKERS] Re: [SQL] prob with aggregate and group by - returns multiples
Previous:From: Tom LaneDate: 2000-02-29 05:40:19
Subject: Re: [HACKERS] Re: ALTER TABLE DROP COLUMN

pgsql-sql by date

Next:From: Thomas LockhartDate: 2000-02-29 05:48:12
Subject: Re: [HACKERS] Re: [SQL] prob with aggregate and group by - returns multiples
Previous:From: Peter EisentrautDate: 2000-02-28 23:19:05
Subject: Re: [SQL] prob with aggregate and group by - returns multiples

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group