Received: from post.gateone.com (qmailr@post.gateone.com [204.244.205.25]) by hub.org (8.8.8/8.7.5) with SMTP id BAA21685 for ; Mon, 27 Jul 1998 01:55:53 -0400 (EDT) Received: (qmail 5704 invoked from network); 27 Jul 1998 05:55:52 -0000 Received: from mistress.gateone.com (HELO wizard.ca) (root@204.244.205.11) by mail.gateone.com with SMTP; 27 Jul 1998 05:55:52 -0000 Sender: root Message-ID: <35BC167B.BDD7D6C7@wizard.ca> Date: Sun, 26 Jul 1998 22:56:13 -0700 From: Michael X-Mailer: Mozilla 4.05 [en] (X11; I; Linux 2.0.0 i586) MIME-Version: 1.0 To: "pgsql-sql@postgreSQL.org" Subject: SubQueries in FROM statement Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit 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' )