Sara Cohen <[EMAIL PROTECTED]> 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
---------------------------(end of broadcast)---------------------------
TIP 6: Have you searched our list archives?
http://www.postgresql.org/search.mpl
- [SQL] Subqueries in select clause Sara Cohen
- Re: [SQL] Subqueries in select clause Tom Lane
- Re: [SQL] Subqueries in select clause Stephan Szabo
- Re: [SQL] Subqueries in select clause Richard Huxton
- Re: [SQL] Subqueries in select clause Josh Berkus
