Home > mailing lists

alias required by standard or PostgreSQL? - Mailing list pgsql-sql

From	Joost Kraaijeveld
Subject	alias required by standard or PostgreSQL?
Date	December 3, 2007 04:52:37
Msg-id	1196661149.5542.33.camel@panoramix.askesis.nl Whole thread Raw
Responses	Re: alias required by standard or PostgreSQL?
List	pgsql-sql

Tree view

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

pgsql-sql by date:

From: Tom Lane
Date: 01 December 2007, 03:08:08
Subject: Re: Crosstab limitation...

From: Tom Lane
Date: 03 December 2007, 05:13:37
Subject: Re: alias required by standard or PostgreSQL?

alias required by standard or PostgreSQL? - Mailing list pgsql-sql

Previous

Next