Re:
| От | Tom Lane |
|---|---|
| Тема | Re: |
| Дата | |
| Msg-id | 17347.1246372003@sss.pgh.pa.us обсуждение исходный текст |
| Ответ на | Re: (Waldemar Bergstreiser <littlesuspense@web.de>) |
| Список | pgsql-general |
Waldemar Bergstreiser <littlesuspense@web.de> writes:
> Just try to rewrite query below with left outter joins. I had not found any compact syntax.
> select * from a, outer( b, outer c), outer (d, outer f )
> where a.b_id = b.id and b.c_id = c.id and a.d_id = d.id and d.f_id = f.id;
This has got pretty much the same problem as Oracle's syntax: there's no
principled way to decide what it *means*. Which join is each of the
WHERE conditions supposed to be attached to, and why? What do you do if
you want a behavior slightly different from whatever the engine decides
it means?
The standard's syntax is a bit more verbose, but at least it's perfectly
clear which conditions are outer-join conditions and which are filters.
regards, tom lane
В списке pgsql-general по дате отправления: