Re: Extend inner join to fetch not yet connected rows also

From: Michael Lewis <mlewis(at)entrata(dot)com>
To: Jan Kohnert <nospam001-lists(at)jan-kohnert(dot)de>
Cc: PostgreSQL General <pgsql-general(at)lists(dot)postgresql(dot)org>
Subject: Re: Extend inner join to fetch not yet connected rows also
Date: 2019-09-22 20:11:17
Message-ID: CAHOFxGrJiCRGkNy8f_kTKE4yn_Bm_oaqzhBbk6R0w0korNkMRA@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Just a side note, that the below can be written more simply-

CASE WHEN UserSkills.craftsmanship_id IS NULL THEN FALSE
ELSE TRUE as has

If you want to be direct-

UserSkills.craftsmanship_id IS NOT NULL as has

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Paul A Jungwirth 2019-09-22 21:34:24 Re: When does Postgres use binary I/O?
Previous Message Adrian Klaver 2019-09-22 19:24:29 Re: Use of ?get diagnostics'?