| From: | "Joel Jacobson" <joel(at)compiler(dot)org> |
|---|---|
| To: | "Laurenz Albe" <laurenz(dot)albe(at)cybertec(dot)at>, pgsql-hackers <pgsql-hackers(at)postgresql(dot)org> |
| Cc: | "Arne Roland" <arne(dot)roland(at)malkut(dot)net>, "Anders Granlund" <anders(dot)granlund(dot)0(at)gmail(dot)com>, "Andreas Karlsson" <andreas(at)proxel(dot)se>, "Vik Fearing" <vik(at)chouppes(dot)com> |
| Subject: | Re: Key joins |
| Date: | 2026-05-31 14:40:06 |
| Message-ID: | 4a34b3e4-fa4c-446d-beb6-45ccac536086@app.fastmail.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
On Sun, May 31, 2026, at 10:05, Joel Jacobson wrote:
> On Fri, May 29, 2026, at 18:20, Laurenz Albe wrote:
>> On Fri, 2026-05-29 at 15:21 +0200, Joel Jacobson wrote:
>>> We actually originally considered TO and FROM as keywords for indicating
>>> direction, but FROM in a join clause causes confusion with the FROM
>>> clause itself. Our user discussions over the last three years indicates
>>> that arrows are clearer and less ambiguous.
>>>
>>> It's also worth to mention that SQL/PGQ also uses ASCII arrows to
>>> indicate direction for its graph pattern syntax.
>>
>> I understand the problem with FROM, and I have no objection to the
>> arrows.
>
> Thanks for reviewing.
>
> v7 updates 0002 to match the revised Change Proposal wording for
> GROUPING SETS/ROLLUP/CUBE:
v8 fixes another nondeterministic isolation-test ordering issue seen by
cfbot on the FreeBSD machine.
0001 and 0003 are unchanged from v7.
/Joel
| Attachment | Content-Type | Size |
|---|---|---|
| v8-0001-Serialize-routine-definition-changes-with-depende.patch.gz | application/x-gzip | 1.9 KB |
| v8-0002-Implement-FOR-KEY-join-support.patch.gz | application/x-gzip | 178.1 KB |
| v8-0003-Add-information_schema.view_constraint_usage.patch.gz | application/x-gzip | 2.9 KB |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Andrew Dunstan | 2026-05-31 15:03:47 | Re: hashjoins vs. Bloom filters (yet again) |
| Previous Message | Shinya Kato | 2026-05-31 13:06:36 | Re: Report oldest xmin source when autovacuum cannot remove tuples |