[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 Kr

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 def