Chris Travers <chris.travers@gmail.com> 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