Postgres Pro
Downloads
Home   >   mailing lists

Re: [HACKERS] Make subquery alias optional in FROM clause - Mailing list pgsql-hackers

From Matthew Woodcraft
Subject Re: [HACKERS] Make subquery alias optional in FROM clause
Date
Msg-id o8uabk$804$1@blaine.gmane.org
Whole thread Raw
In response to Re: [HACKERS] Make subquery alias optional in FROM clause  (Robert Haas <robertmhaas@gmail.com>)
List pgsql-hackers
Tree view 
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-

pgsql-hackers by date:

Previous
From: Robins Tharakan
Date:
Subject: Re: [HACKERS] Allow pg_dumpall to work without pg_authid
Next
From: Robert Haas
Date:
Subject: Re: [HACKERS] Allow pg_dumpall to work without pg_authid