Re: Subqueries in select clause

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Sara Cohen <sarina(at)cs(dot)huji(dot)ac(dot)il>
Cc: pgsql-sql(at)postgresql(dot)org
Subject: Re: Subqueries in select clause
Date: 2001-04-18 14:12:43
Message-ID: 9423.987603163@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

Sara Cohen <sarina(at)cs(dot)huji(dot)ac(dot)il> 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

In response to

Browse pgsql-sql by date

  From Date Subject
Next Message Lamar Owen 2001-04-18 14:14:13 Re: [GENERAL] Where are the 7.1 RPM's?
Previous Message Roberto Mello 2001-04-18 13:34:30 Re: maybe Offtopic : PostgreSQL & PHP ?