Horton

Re: Key joins

Laurenz Albe <laurenz.albe@cybertec.at>

View thread
From: Laurenz Albe <laurenz.albe@cybertec.at>
To: Joel Jacobson <joel@compiler.org>, pgsql-hackers <pgsql-hackers@postgresql.org>
Cc: Arne Roland <arne.roland@malkut.net>, Anders Granlund <anders.granlund.0@gmail.com>, Andreas Karlsson <andreas@proxel.se>, Vik Fearing <vik@chouppes.com>
Date: 2026-05-29T16:20:19Z
Lists: pgsql-hackers 
On Fri, 2026-05-29 at 15:21 +0200, Joel Jacobson wrote:
> In the spirit of looking more like SQL, how about replacing the
> > arrows with FROM and TO?
> 
> 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.

Yours,
Laurenz Albe