| From: | Thomas Lockhart <lockhart(at)alumni(dot)caltech(dot)edu> |
|---|---|
| To: | Peter Eisentraut <peter_e(at)gmx(dot)net> |
| Cc: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, George Dau <gedau(at)isa(dot)mim(dot)com(dot)au>, "'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:48:12 |
| Message-ID: | 38BB5D9C.ED50B126@alumni.caltech.edu |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers pgsql-sql |
> > Postgres thinks that TEMP is a keyword, so it won't take it as a table
> > name unless you put quotes around it.
> 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? Saving an extra 5
characters of typing is not a good enough reason to keep it imho, and
if the SQL92 standard requires a particular form why bother extending
it?
A major release is a good time to adjust syntax to promote
compliance...
- Thomas
--
Thomas Lockhart lockhart(at)alumni(dot)caltech(dot)edu
South Pasadena, California
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Thomas Lockhart | 2000-02-29 05:54:56 | Re: [HACKERS] Re: NOT {NULL|DEFERRABLE} (was: bug in 7.0) |
| Previous Message | Tom Lane | 2000-02-29 05:44:22 | Re: [HACKERS] Re: [SQL] prob with aggregate and group by - returns multiples |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Bruce Momjian | 2000-02-29 05:59:12 | Re: [HACKERS] Re: [SQL] prob with aggregate and group by - returns multiplesh |
| Previous Message | Tom Lane | 2000-02-29 05:44:22 | Re: [HACKERS] Re: [SQL] prob with aggregate and group by - returns multiples |