Tod McQuillin <devin(at)spamcop(dot)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