Postgres Pro
Downloads
Home   >   mailing lists

Re: Postgres views cannot use both union and join/where - Mailing list pgsql-performance

From Michael Lewis
Subject Re: Postgres views cannot use both union and join/where
Date
Msg-id CAHOFxGppNR3m4Dc-1nL-YA-sqWjSWs7JEx7EgoPnPKk_-7c5KA@mail.gmail.com
Whole thread Raw
In response to Postgres views cannot use both union and join/where  (Mithran Kulasekaran <mithranakulasekaran@gmail.com>)
Responses Re: Postgres views cannot use both union and join/where
List pgsql-performance
Tree view
On Tue, Oct 19, 2021 at 3:48 PM Mithran Kulasekaran <mithranakulasekaran@gmail.com> wrote:
create  view template_view (id, name, description, is_staged) as
select t.id,t.name, t.description, false as is_staged
from template t
         left join template_staging ts on t.name = ts.name and ts.name is null

Does that work? I've only seen that type of logic written as-

left join template_staging ts on t.name = ts.name
where ts.name is null

pgsql-performance by date:

Previous
From: Benedict Holland
Date:
Subject: Re: Postgres views cannot use both union and join/where
Next
From: "David G. Johnston"
Date:
Subject: Re: Postgres views cannot use both union and join/where