Received: from sss.pgh.pa.us ([216.151.103.158]) by postgresql.org (8.11.3/8.11.1) with ESMTP id f3IED1u73240 for ; Wed, 18 Apr 2001 10:13:01 -0400 (EDT) (envelope-from tgl@sss.pgh.pa.us) Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss.pgh.pa.us (8.11.3/8.11.3) with ESMTP id f3IEChR09426; Wed, 18 Apr 2001 10:12:43 -0400 (EDT) To: Sara Cohen cc: pgsql-sql@postgresql.org Subject: Re: Subqueries in select clause In-reply-to: References: Comments: In-reply-to Sara Cohen message dated "Wed, 18 Apr 2001 12:45:50 +0300" Date: Wed, 18 Apr 2001 10:12:43 -0400 Message-ID: <9423.987603163@sss.pgh.pa.us> From: Tom Lane X-Archive-Number: 200104/302 X-Sequence-Number: 2658 Sara Cohen writes: > Using Oracle, I could get by this problem with: > select max(d) from ((select count(b) as d from c group by a)); > However, my version of postgres doesn't support subqueries in the from > clause. Time to update to 7.1... regards, tom lane