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