| From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
|---|---|
| To: | Alvaro Herrera <alvherre(at)commandprompt(dot)com> |
| Cc: | Michael Glaesemann <grzm(at)seespotcode(dot)net>, Josh Berkus <josh(at)agliodbs(dot)com>, pgsql-hackers(at)postgresql(dot)org |
| Subject: | Re: SQL feature requests |
| Date: | 2007-08-23 20:06:38 |
| Message-ID: | 11949.1187899598@sss.pgh.pa.us |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
Alvaro Herrera <alvherre(at)commandprompt(dot)com> writes:
> Michael Glaesemann wrote:
>> How about something like gensym?
> It is dangerous to provide a synthetic name; if the standard ever gets
> modified to support alias-less subqueries, they would likely choose a
> different name-generating algorithm, and we would have a
> backward-compatibility problem.
I concur. If we do this, the thing to do is have *no* alias, ie, there
is no way to qualify the names of the subquery output columns. (IIRC
unaliased joins already work approximately like that.) Then there's
not anything to have a backward compatibility problem with.
regards, tom lane
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Peter Eisentraut | 2007-08-23 20:10:21 | Re: [COMMITTERS] pgsql: Add configure option --with-system-tzdata to use operating system |
| Previous Message | Josh Berkus | 2007-08-23 20:05:42 | Re: SQL feature requests |