| From: | Peter Eisentraut <peter(dot)eisentraut(at)2ndquadrant(dot)com> |
|---|---|
| To: | pgsql-hackers <pgsql-hackers(at)postgresql(dot)org> |
| Subject: | Allow an alias to be attached directly to a JOIN ... USING |
| Date: | 2019-06-17 14:40:57 |
| Message-ID: | 454638cf-d563-ab76-a585-2564428062af@2ndquadrant.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
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 | Content-Type | Size |
|---|---|---|
| 0001-Allow-an-alias-to-be-attached-directly-to-a-JOIN-.-U.patch | text/plain | 8.6 KB |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Juan José Santamaría Flecha | 2019-06-17 14:42:32 | Re: [PATCH] Stop ALTER SYSTEM from making bad assumptions |
| Previous Message | Peter Eisentraut | 2019-06-17 14:34:36 | Re: pg_log_fatal vs pg_log_error |