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

Tom Lane <tgl@sss.pgh.pa.us>

From: Tom Lane <tgl@sss.pgh.pa.us>
To: Thomas Lockhart <lockhart@alumni.caltech.edu>
Cc: "'pgsql-sql@postgresql.org'" <pgsql-sql@postgresql.org>, PostgreSQL Development <pgsql-hackers@postgresql.org>
Date: 2000-02-29T05:44:22Z
Lists: pgsql-hackers
Thomas Lockhart <lockhart@alumni.caltech.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