Postgres Pro
Downloads
Home   >   mailing lists

Allow an alias to be attached directly to a JOIN ... USING - Mailing list pgsql-hackers

From Peter Eisentraut
Subject Allow an alias to be attached directly to a JOIN ... USING
Date
Msg-id 454638cf-d563-ab76-a585-2564428062af@2ndquadrant.com
Whole thread Raw
Responses Re: Allow an alias to be attached directly to a JOIN ... USING
Re: Allow an alias to be attached directly to a JOIN ... USING
List pgsql-hackers
Tree view 
A small new feature in SQL:2016 allows attaching a table alias to a
JOIN/USING construct:

    <named columns join> ::=
      USING <left paren> <join column list> <right paren>
      [ AS <join correlation name> ]

(The part in brackets is new.)

This seems quite useful, and it seems the code would already support
this if we allow the grammar to accept this syntax.

Patch attached.

-- 
Peter Eisentraut              http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services
Attachment

pgsql-hackers by date:

Previous
From: Peter Eisentraut
Date:
Subject: Re: pg_log_fatal vs pg_log_error
Next
From: Juan José Santamaría Flecha
Date:
Subject: Re: [PATCH] Stop ALTER SYSTEM from making bad assumptions