Horton

Re: Foreign key joins revisited

Adam Brusselback <adambrusselback@gmail.com>

View thread
From: Adam Brusselback <adambrusselback@gmail.com>
To: Tom Lane <tgl@sss.pgh.pa.us>
Cc: Joel Jacobson <joel@compiler.org>, Isaac Morland <isaac.morland@gmail.com>, Corey Huinker <corey.huinker@gmail.com>, PostgreSQL Developers <pgsql-hackers@lists.postgresql.org>
Date: 2021-12-28T19:47:19Z
Lists: pgsql-hackers 
 > How about JOIN WITH?
I'm -1 on this, reusing WITH is just likely to cause confusion because WITH
can appear other places in a query having an entirely different meaning.
I'd just avoid that from the start.

>> Can with think of some other suitable reserved keyword?
>FOREIGN?  Or even spell out "JOIN FOREIGN KEY".
I like the conciseness of just FOREIGN.