Re: [SQL] SubQueries in FROM statement

From: Vadim Mikheev <vadim(at)krs(dot)ru>
To: Michael <wwwadmin(at)wizard(dot)ca>
Cc: "pgsql-sql(at)postgreSQL(dot)org" <pgsql-sql(at)postgreSQL(dot)org>
Subject: Re: [SQL] SubQueries in FROM statement
Date: 1998-07-27 06:14:22
Message-ID: 35BC1ABE.7DC09BB8@krs.ru
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
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

In response to

Browse pgsql-sql by date

  From Date Subject
Next Message Tod Hagan 1998-07-27 17:24:33 Can Postgres functions be used as stored procedures?
Previous Message Michael 1998-07-27 05:56:13 SubQueries in FROM statement