Re: Sv: how to build this query ??? Please help !!! - Mailing list pgsql-sql

Tod McQuillin <devin@spamcop.net> writes:
> I don't think the PostgreSQL User's Manual mentions sub-selects.

I think you are right :-(.  Geez, that's a pretty big hole in the
docs coverage.

There is some stuff in the Tutorial --- see
http://www.postgresql.org/devel-corner/docs/postgres/sql-language.htm#SELECT
and page down to "Subqueries".  Note that the subquery-in-FROM feature
is new in 7.1.
        regards, tom lane