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