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
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers pgsql-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

Browse pgsql-hackers by date

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

Browse pgsql-sql by date

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