Chris Travers <chris.travers@xxxxxxxxx> 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 (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
