Re: Extend inner join to fetch not yet connected rows also - Mailing list pgsql-general

From Jan Kohnert
Subject Re: Extend inner join to fetch not yet connected rows also
Date
Msg-id 1780284.qfRisySgFs@kohni-mobil
Whole thread Raw
In response to Extend inner join to fetch not yet connected rows also  (Arup Rakshit <ar@zeit.io>)
Responses Re: Extend inner join to fetch not yet connected rows also
Re: Extend inner join to fetch not yet connected rows also
List pgsql-general
Hey,

Am Sonntag, 22. September 2019, 13:21:46 CEST schrieb Arup Rakshit:
> I have craftsmanships table which has (id, name) and users table (id, email,
> ..). When a user has some craftsmanships, they are stored inside the
> contractor_skills(user_id, craftsmanship_id, id) table.

[...]

> But I want to list all craftsmanships and has column should have `t` when
> user_id #8 has it, else `f`. How can I extend this     query?

maybe something like

select
    c.id,
    c.name,
    case when cs.user_id = 8 then true else false end as has
from craftsmanships c
left join contractor_skills cs
    on cs.craftsmanship_id = c.craftmanship_id;

-- 
MfG Jan





pgsql-general by date:

Previous
From: Arup Rakshit
Date:
Subject: Extend inner join to fetch not yet connected rows also
Next
From: Arup Rakshit
Date:
Subject: Re: Extend inner join to fetch not yet connected rows also