[SQL] alias required by standard or PostgreSQL?
Hi, If I run the query "select * from (select * from table_name)" PostgreSQL complains with ERROR: subquery in FROM must have an alias HINT: For example, FROM (SELECT ...) [AS] foo. Is the alias required by the ISO standard or is this a PostgreSQL requirement? TIA -- Groeten, Joost Kraaijeveld Askesis B.V. Molukkenstraat 14 6524NB Nijmegen tel: 024-3888063 / 06-51855277 fax: 024-3608416 web: www.askesis.nl ---(end of broadcast)--- TIP 9: In versions below 8.0, the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match
Re: [SQL] alias required by standard or PostgreSQL?
"Joost Kraaijeveld" <[EMAIL PROTECTED]> writes: > "select * from (select * from table_name)" > PostgreSQL complains with > ERROR: subquery in FROM must have an alias > HINT: For example, FROM (SELECT ...) [AS] foo. > Is the alias required by the ISO standard Yes. A FROM-clause entry is defined as ::= [ [ AS ] [] ] | [ AS ] [] | ::= Note that the brackets show that a (ie, an alias) is optional for a regular table, but not for a subquery. regards, tom lane ---(end of broadcast)--- TIP 2: Don't 'kill -9' the postmaster
