Re: oracle ambiguity, inline views

"Edmar Wiggers" <edmar@brasmap.com> writes:

One other thing: will PostgreSQL support in-line views?
Works like this:
select a,b,c
from table_a a, (select b2 from table_b2 join... where ...) b, table_c c
where...

Yes, that's in there for 7.1. I hadn't heard the phrase "in-line view"
before; I've been calling it "sub-SELECT in FROM".

It's a feature only available in oracle8, I think.

It's in the SQL92 spec (and it looks like Oracle even used the
standard's syntax for it, praise be ;-)) so I would expect that a
fair number of DBMSs have support for it.

regards, tom lane