Postgres Pro
Downloads
Home   >   mailing lists

Re: Subqueries in select clause - Mailing list pgsql-sql

From Tom Lane
Subject Re: Subqueries in select clause
Date
Msg-id 9423.987603163@sss.pgh.pa.us
Whole thread Raw
In response to Subqueries in select clause  (Sara Cohen <sarina@cs.huji.ac.il>)
List pgsql-sql
Tree view 
Sara Cohen <sarina@cs.huji.ac.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

pgsql-sql by date:

Previous
From: Roberto Mello
Date:
Subject: Re: maybe Offtopic : PostgreSQL & PHP ?
Next
From: Stephan Szabo
Date:
Subject: Re: Subqueries in select clause