Horton

Re: [SQL] SubQueries in FROM statement

Vadim Mikheev <vadim@krs.ru>

View thread View on postgr.es
From: Vadim Mikheev <vadim@krs.ru>
To: Michael <wwwadmin@wizard.ca>
Cc: "pgsql-sql@postgreSQL.org" <pgsql-sql@postgreSQL.org>
Date: 1998-07-27T06:14:22Z
Lists: pgsql-sql 
Michael wrote:
> 
> I see that now the use of SubQueries are allowed in certain cases, but
> is there any plans in the works to sllow subqueries in the FROM
> statement.. ie
> 
> SELECT count(cats)
>     FROM (
>             SELECT name AS cats
>                 FROM animals
>                 WHERE species='feline'
>             )

6.5 or 6.6... :(

Vadim