pg.ddx.io  pgsql-sql@postgresql.org mailing list archive  
help / color / mirror / Atom feed
SubQueries in FROM statement
2+ messages / 2 participants
[nested] [flat]

* SubQueries in FROM statement
@ 1998-07-27 05:56 Michael <wwwadmin@wizard.ca>
  1998-07-27 06:14 ` Re: [SQL] SubQueries in FROM statement Vadim Mikheev <vadim@krs.ru>
  0 siblings, 1 reply; 2+ messages in thread

From: Michael @ 1998-07-27 05:56 UTC (permalink / raw)
  To: 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'
            )





^ permalink  raw  reply  [nested|flat] 2+ messages in thread

* Re: [SQL] SubQueries in FROM statement
  1998-07-27 05:56 SubQueries in FROM statement Michael <wwwadmin@wizard.ca>
@ 1998-07-27 06:14 ` Vadim Mikheev <vadim@krs.ru>
  0 siblings, 0 replies; 2+ messages in thread

From: Vadim Mikheev @ 1998-07-27 06:14 UTC (permalink / raw)
  To: Michael <wwwadmin@wizard.ca>; +Cc: 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



^ permalink  raw  reply  [nested|flat] 2+ messages in thread


end of thread, other threads:[~1998-07-27 06:14 UTC | newest]

Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
1998-07-27 05:56 SubQueries in FROM statement Michael <wwwadmin@wizard.ca>
1998-07-27 06:14 ` Vadim Mikheev <vadim@krs.ru>

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox