Postgres Pro
Downloads
Home   >   mailing lists

Re: [SQL] SubQueries in FROM statement - Mailing list pgsql-sql

From Vadim Mikheev
Subject Re: [SQL] SubQueries in FROM statement
Date
Msg-id 35BC1ABE.7DC09BB8@krs.ru
Whole thread Raw
In response to SubQueries in FROM statement  (Michael <wwwadmin@wizard.ca>)
List pgsql-sql
Tree view 
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

pgsql-sql by date:

Previous
From: Michael
Date:
Subject: SubQueries in FROM statement
Next
From: Tod Hagan
Date:
Subject: Can Postgres functions be used as stored procedures?