SubQueries in FROM statement

From: Michael <wwwadmin(at)wizard(dot)ca>
To: "pgsql-sql(at)postgreSQL(dot)org" <pgsql-sql(at)postgreSQL(dot)org>
Subject: SubQueries in FROM statement
Date: 1998-07-27 05:56:13
Message-ID: 35BC167B.BDD7D6C7@wizard.ca
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

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'
)

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Vadim Mikheev 1998-07-27 06:14:22 Re: [SQL] SubQueries in FROM statement
Previous Message Leslie Mikesell 1998-07-26 17:49:09 Re: [SQL] Select Query Help