Postgres Pro
Downloads
Home   >   mailing lists

Re: Foreign key joins revisited - Mailing list pgsql-hackers

From Adam Brusselback
Subject Re: Foreign key joins revisited
Date
Msg-id CAMjNa7ds1HRKA8zXVm858Be--a33YvvN+XnEqi1=yXHPPVdr-Q@mail.gmail.com
Whole thread Raw
In response to Re: Foreign key joins revisited  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-hackers
Tree view
 > 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.

pgsql-hackers by date:

Previous
From: Vik Fearing
Date:
Subject: Re: Foreign key joins revisited
Next
From: Tom Lane
Date:
Subject: Re: [PROPOSAL] Make PSQLVAR on \getenv opitional