Skip site navigation (1) Skip section navigation (2)

Subselect in join?

From: "Kenn Thompson" <kthompson(at)adestagroup(dot)com>
To: <pgsql-sql(at)postgresql(dot)org>
Subject: Subselect in join?
Date: 2000-11-30 00:24:39
Message-ID: sa2549f7.059@10.0.0.4 (view raw or flat)
Thread:
Lists: pgsql-sql
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 implemented feature?

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



Responses

pgsql-sql by date

Next:From: Tom LaneDate: 2000-11-30 00:42:53
Subject: Re: [SQL] Rules with Conditions: Bug, or Misunderstanding
Previous:From: Joel BurtonDate: 2000-11-30 00:07:57
Subject: Re: Cache look up failure

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group