Re: Join Correlation Name

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.