| From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
|---|---|
| To: | "Edmar Wiggers" <edmar(at)brasmap(dot)com> |
| Cc: | pgsql-general(at)postgreSQL(dot)org |
| Subject: | Re: oracle ambiguity, inline views |
| Date: | 2000-10-20 02:08:01 |
| Message-ID: | 17043.972007681@sss.pgh.pa.us |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
"Edmar Wiggers" <edmar(at)brasmap(dot)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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Edmar Wiggers | 2000-10-20 02:46:54 | RE: prefer (+) oracle notation. Let's use standard and that's it |
| Previous Message | Alex Pilosov | 2000-10-20 02:03:07 | Re: MySQL -> pgsql |