On 2017-02-23 08:21:41 +0530, Robert Haas wrote: > On Wed, Feb 22, 2017 at 10:33 PM, Nico Williams <n...@cryptonector.com> wrote: > > On Wed, Feb 22, 2017 at 10:08:38AM -0500, Tom Lane wrote: > >> Bernd Helmle <maili...@oopsware.de> writes: > >> >> From time to time, especially during migration projects from Oracle to > >> > PostgreSQL, i'm faced with people questioning why the alias in the FROM > >> > clause for subqueries in PostgreSQL is mandatory. The default answer > >> > here is, the SQL standard requires it. > >> > >> Indeed. When I wrote the comment you're referring to, quite a few years > >> ago now, I thought that popular demand might force us to allow omitted > >> aliases. But the demand never materialized. At this point it seems > >> clear to me that there isn't really good reason to exceed the spec here. > >> It just encourages people to write unportable SQL code. > > > > 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.
+1, too. -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers
