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/ ?
--
Peter Eisentraut http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services
