Postgres Pro
Downloads
Home   >   mailing lists

Subselect in join? - Mailing list pgsql-sql

From Kenn Thompson
Subject Subselect in join?
Date
Msg-id sa2549f7.059@10.0.0.4
Whole thread Raw
Responses Re: Subselect in join?
List pgsql-sql
Tree view 
Ok- Seems I've seen this somewhere, but can't seem to get it to work. Is my memory flawed, or is this just not an
implementedfeature?
 

SELECT * FROM (SELECT foo, bar FROM tfoobar)

In english- is it not possible to to a subselect in a FROM clause?

Kenn


____________________________________________
Kenn Thompson
Senior Web Architect
Adesta Communications
Work: 402.233.7595
Cell: 402.210.6326

pgsql-sql by date:

Previous
From: Joseph Shraibman
Date:
Subject: subselects
Next
From: Tom Lane
Date:
Subject: Re: Rules with Conditions: Bug, or Misunderstanding