Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.96) (envelope-from ) id 1wSzwh-000FUV-2h for pgsql-hackers@arkaria.postgresql.org; Fri, 29 May 2026 16:20:28 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.96) (envelope-from ) id 1wSzwe-003Mae-0k for pgsql-hackers@arkaria.postgresql.org; Fri, 29 May 2026 16:20:24 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.96) (envelope-from ) id 1wSzwd-003MaW-2x for pgsql-hackers@lists.postgresql.org; Fri, 29 May 2026 16:20:24 +0000 Received: from mail-wm1-x32d.google.com ([2a00:1450:4864:20::32d]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.98.2) (envelope-from ) id 1wSzwc-00000000AQ2-1Beb for pgsql-hackers@postgresql.org; Fri, 29 May 2026 16:20:23 +0000 Received: by mail-wm1-x32d.google.com with SMTP id 5b1f17b1804b1-49048e043e5so62745955e9.1 for ; Fri, 29 May 2026 09:20:21 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=cybertec.at; s=google; t=1780071621; x=1780676421; darn=postgresql.org; h=mime-version:user-agent:content-transfer-encoding:references :in-reply-to:date:cc:to:from:subject:message-id:from:to:cc:subject :date:message-id:reply-to; bh=2tG77/eS7ezpfENl1RiIjQWabBOQSDiwBc7iXay2p2Q=; b=fk/2Dcbx3PL51t4vlHTGF7uTH7qjpA/h5qdKl0fsxLxwiCOt7APLACA7LhrQfD7HpM PTfbIriJ/7ELAjf2+8bOYBThc2a6i/kG09XhH1GhJOGlZSMpI0w2zw3DzL2IrjEd6ZXb hYmeie+aWw+Biw4x4SZrrlLavLzYK8RU2owCAR+i0BbQPSTppMf2xdWUdRfXG8mS6Q72 z9fYysL2lMgIP4+QEmzv2xh65utsrJ/I7Tb8QtBg4gHb8q2hU6mMVl6S23neBfBrN5da 78wT24vvF769kjq/60w2QSShZR7DJjVaiOFeZdG+uFzzAeix2dvTBcHJrYhvfNlNdeCM tnFQ== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20251104; t=1780071621; x=1780676421; h=mime-version:user-agent:content-transfer-encoding:references :in-reply-to:date:cc:to:from:subject:message-id:x-gm-gg :x-gm-message-state:from:to:cc:subject:date:message-id:reply-to; bh=2tG77/eS7ezpfENl1RiIjQWabBOQSDiwBc7iXay2p2Q=; b=HlL79/LBAy8442Wo3oA5vt6yxyOimzuBuGx0dFyxJ6FVooYvEe4xVq88K2hZRQbkBV V482NrViVdnGHPEnpIVdlM5ampw532NviQBD44KFCZrj9cSgTLkDBHgxQPIGgBXeT0HM kOZRfbYI/Kf/rL1QnMyFDxxxdPT10yihBsl8XfTIDkj6SeognE8wDgj5Rb/T+VJMdq7q TGcYaG93ZSyZXQyB4x9dg+vehALWqykza7ajjTXsh/xlKLvMK1QC6Mti6/9s3/19zhnL CaXxmognija8O3nEG4Q6pOmX8O2qC0NqMo0I0tIJ3T+ecUAIYNBHXs8H8sRrvYB9vHr2 ldDQ== X-Forwarded-Encrypted: i=1; AFNElJ/7YJot27dQ2mMrC9RPkT1BIsA+LE9RtXQNXkcusEBwUdkLiZ0WDapgM49jzbzRseOj5LXhrbtuKEk4ABG4@postgresql.org X-Gm-Message-State: AOJu0YxXEEOnmHJSIeP2plypv5hKnXzuK4B8hhR+uKqudwGwdjVsQAbJ 8851UcFLoMkLlVxFahkoLzSWqppA19Y8qvG9Ob6lv2am5OuS7TusbUYx6mT8XZapuUs= X-Gm-Gg: Acq92OHl1GIsoRBibUYPfOkHs0AecIzXqwii3MAws687NTnP5gsOnDVhOpcWhJpuueX o1qQACtOM37R6EtMsx4It++/5sukCkEixOzYAOIZdCdi+ICFuEhszUytOtvIUSbU4u2qiZAjOIg JMkjtwr6zzZKS5mu0jAvdZRbVGcTx14iNvJ0knRdir0IF5fQPSuTmGvyDFdAs2/5i13JYsQn4xd NRi7vBaVT3UB83HEgIJ+rgBKD/YG/ks5yNXF+bLxCKKsVhuOTH+5t08Ky6oTfzpv26gQLRhK9/a SFREW9LSMLGR0polskYzXAtSd3kbycqU+W0eyIgfmxvSKANsnW3061rwyUZMuPvsQOVbnt/dq4O rmgjFouYK3V0M4Kb3E43qwFXpZcz3EVy/I5bVBVWFnTTNuXYZpiG+8Pri3ZR/2IiSTVAsP65GZM MmaqqFzkMWDntCLOsDd5PJKtPnb3HVpszx/ZWG7fDk+oSEvN4+ma4hGQxVLl3aE4gs X-Received: by 2002:a05:600c:e48a:b0:490:3c94:a3c6 with SMTP id 5b1f17b1804b1-490a293a8d9mr2761185e9.26.1780071620756; Fri, 29 May 2026 09:20:20 -0700 (PDT) Received: from laurenz.albe-K4N0CV00F97414D ([2001:871:260:1eae:8a4d:7458:2f2f:5ed4]) by smtp.gmail.com with ESMTPSA id 5b1f17b1804b1-4909cab0e94sm53956195e9.12.2026.05.29.09.20.20 (version=TLS1_3 cipher=TLS_AES_256_GCM_SHA384 bits=256/256); Fri, 29 May 2026 09:20:20 -0700 (PDT) Message-ID: <348b4bd1d4215d475952b7f5527a092a1491a2c1.camel@cybertec.at> Subject: Re: Key joins From: Laurenz Albe To: Joel Jacobson , pgsql-hackers Cc: Arne Roland , Anders Granlund , Andreas Karlsson , Vik Fearing Date: Fri, 29 May 2026 18:20:19 +0200 In-Reply-To: <2ac20bea-4130-4cf3-8e13-ea7c6d062296@app.fastmail.com> References: <00c30670-64e1-4c30-a349-784426d333df@app.fastmail.com> <264e69aed5a2fdd93ad555dff96daeabc5c35724.camel@cybertec.at> <2ac20bea-4130-4cf3-8e13-ea7c6d062296@app.fastmail.com> Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: quoted-printable User-Agent: Evolution 3.58.3 (3.58.3-1.fc43) MIME-Version: 1.0 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk 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? >=20 > 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.=C2=A0 Our user discussions over the last three years indic= ates > that arrows are clearer and less ambiguous. >=20 > 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