Search Postgresql Archives

Re: Displaying chat by punished users only to themselves (db fiddle attached)

Subject: Re: Displaying chat by punished users only to themselves (db fiddle attached)
From: Alexander Farber <alexander.farber@xxxxxxxxx>
Date: Wed, 4 May 2022 17:39:58 +0200
Cc: pgsql-general <pgsql-general@xxxxxxxxxxxxxx>
In-reply-to: <CAADeyWgSy_RurtG0zDTm8YsP81SOtfOBhe0q+d4SsqROXTAp+A@mail.gmail.com>
References: <CAADeyWiCoYPsVkVjBNZ1wnyeTnADjiyo_hYaZLMGG2bA6C1rBQ@mail.gmail.com> <CAKFQuwZ9erudCJ9npv5_dZEsuyV6QPv_sH2JZPJZZHZQuxhsfA@mail.gmail.com> <CAADeyWhZamV5ZEkvwEj-Qnm+NcSsx+0T7cz6nM0hCwOvZbqPOg@mail.gmail.com> <CAKFQuwb7eFbS69BA+hkcA=Bz=MZcAQjhRTeZK899V=44+ymqpw@mail.gmail.com> <CAADeyWgSy_RurtG0zDTm8YsP81SOtfOBhe0q+d4SsqROXTAp+A@mail.gmail.com>

I am probably needing LEFT JOIN LATERAL here (and am completely lost)?

Or to switch to CTE as you suggest

References:
- Displaying chat by punished users only to themselves (db fiddle attached)
  - From: Alexander Farber
- Re: Displaying chat by punished users only to themselves (db fiddle attached)
  - From: David G. Johnston
- Re: Displaying chat by punished users only to themselves (db fiddle attached)
  - From: Alexander Farber
- Re: Displaying chat by punished users only to themselves (db fiddle attached)
  - From: David G. Johnston
- Re: Displaying chat by punished users only to themselves (db fiddle attached)
  - From: Alexander Farber