Re: Foreign key joins revisited

From: "Joel Jacobson" <joel(at)compiler(dot)org>
To: "Sascha Kuhl" <yogidabanli(at)gmail(dot)com>
Cc: "PostgreSQL Hackers" <pgsql-hackers(at)lists(dot)postgresql(dot)org>
Subject: Re: Foreign key joins revisited
Date: 2021-12-26 19:00:09
Message-ID: 287c0a1b-d499-4ff6-a625-539801f42bd0@www.fastmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On Sun, Dec 26, 2021, at 19:54, Sascha Kuhl wrote:
> Could you make
>
> JOIN key ?

Not sure what you mean.
Perhaps you can explain by rewriting the normal query below according to your idea?

SELECT *
FROM permission p
LEFT JOIN role r ON p.role_id = r.id

Given the foreign key on "permission" that references "role" is named "permission_role_id_fkey".

/Joel

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Isaac Morland 2021-12-26 19:02:36 Re: Foreign key joins revisited
Previous Message Sascha Kuhl 2021-12-26 18:54:40 Re: Foreign key joins revisited