Chris Travers <[email protected]> writes:
> I came across a query someone posted in the form of:
> SELECT *
> FROM [table_list]
> INHERITS ([table_list]);
> Naturally, never having seen this before I consulted the docs and there was
> nothing there that I could find. So I ran some tests and the syntax seems
> supported.
There's no such syntax in Postgres. It's hard to be sure without seeing
the query you actually ran, but I'm betting the parser thought that
INHERITS was a table alias and the stuff inside parens column aliases.
(Whoever decided that AS should be optional in SQL aliases was a fool.)
regards, tom lane
--
Sent via pgsql-general mailing list ([email protected])
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
