Re: select ... inherits?

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