Re: Make subquery alias optional in FROM clause

From: Pantelis Theodosiou <ypercube(at)gmail(dot)com>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: Robert Haas <robertmhaas(at)gmail(dot)com>, Nico Williams <nico(at)cryptonector(dot)com>, Bernd Helmle <mailings(at)oopsware(dot)de>, PostgreSQL Development <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: Make subquery alias optional in FROM clause
Date: 2017-02-23 10:38:20
Message-ID: CAE3TBxzq=QWg37bW6qHByJpO-5x0_t4oomogjgxmE2m9uynf_w@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On Thu, Feb 23, 2017 at 3:17 AM, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> wrote:

> Robert Haas <robertmhaas(at)gmail(dot)com> writes:
> > On Wed, Feb 22, 2017 at 10:33 PM, Nico Williams <nico(at)cryptonector(dot)com>
> wrote:
> >> I suspect most users, like me, just roll their eyes, grumble, and put up
> >> with it rather than complain. It's a pain point, but tolerable enough
> >> that no one bothers to demand a change. Now that it's been done though,
> >> allow me to add my voice in favor of it!
>
> > +1 to all of that.

My vote doesn't count much but it would be -1.

Question: Will the patch be removed if and when Oracle decides to be
compatible with the standard and forbids non-aliased derived tables?

(I know it's a rather theoretical question. Unlikely that Oracle breaks
backwards compatibility on that.)

Pantelis Theodosiou

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Pavel Stehule 2017-02-23 11:17:31 proposal - psql: possibility to specify sort for describe commands, when size is printed
Previous Message Amit Langote 2017-02-23 10:32:55 Re: UPDATE of partition key