Re: oracle ambiguity, inline views

"Edmar Wiggers"  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