Re: Make subquery alias optional in FROM clause

From: Matthew Woodcraft <matthew(at)woodcraft(dot)me(dot)uk>
To: pgsql-hackers(at)postgresql(dot)org
Subject: Re: Make subquery alias optional in FROM clause
Date: 2017-02-26 10:23:54
Message-ID: o8uabk$804$1@blaine.gmane.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On 2017-02-24 07:25, Robert Haas wrote:
> I don't think it's only Oracle that allows omitting the
> alias; I think there are a number of other systems that behave
> similarly.

SQLite, for example.

Making conversions from SQLite to Postgres easier is a Good Thing.
"subquery in FROM must have an alias" has caused me inconvenience doing
that as recently as last week.

-M-

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Robert Haas 2017-02-26 10:37:25 Re: Allow pg_dumpall to work without pg_authid
Previous Message Robins Tharakan 2017-02-26 10:13:46 Re: Allow pg_dumpall to work without pg_authid