Postgres Pro
Downloads
Home   >   mailing lists

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

From Michael Lewis
Subject Re: Extend inner join to fetch not yet connected rows also
Date
Msg-id CAHOFxGrJiCRGkNy8f_kTKE4yn_Bm_oaqzhBbk6R0w0korNkMRA@mail.gmail.com
Whole thread Raw
In response to Re: Extend inner join to fetch not yet connected rows also  (Jan Kohnert <nospam001-lists@jan-kohnert.de>)
List pgsql-general
Tree view
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

pgsql-general by date:

Previous
From: Adrian Klaver
Date:
Subject: Re: Use of ?get diagnostics'?
Next
From: Paul A Jungwirth
Date:
Subject: Re: When does Postgres use binary I/O?