Re: Join Correlation Name
| От | Vik Fearing |
|---|---|
| Тема | Re: Join Correlation Name |
| Дата | |
| Msg-id | 25fea7ef-4672-fed0-f655-b9bbda118b79@2ndquadrant.com обсуждение исходный текст |
| Ответ на | Re: Join Correlation Name (Peter Eisentraut <peter.eisentraut@2ndquadrant.com>) |
| Список | pgsql-hackers |
On 29/10/2019 12:05, Peter Eisentraut wrote: > On 2019-10-29 11:47, Vik Fearing wrote: >> When joining tables with USING, the listed columns are merged and no >> longer belong to either the left or the right side. That means they can >> no longer be qualified which can often be an inconvenience. >> >> >> SELECT a.x, b.y, z FROM a INNER JOIN b USING (z); >> >> >> The SQL standard provides a workaround for this by allowing an alias on >> the join clause. (<join correlation name> in section 7.10) >> >> >> SELECT j.x, j.y, j.z FROM a INNER JOIN b USING (z) AS j; >> >> >> Attached is a patch (based on 517bf2d910) adding this feature. > > Is this the same as https://commitfest.postgresql.org/25/2158/ ? Crap. Yes, it is.
В списке pgsql-hackers по дате отправления: