Re: Poor plan when using EXISTS in the expression list - Mailing list pgsql-hackers

From Geoff Winkless
Subject Re: Poor plan when using EXISTS in the expression list
Date
Msg-id CAEzk6fdLWr+RGQN0D+L50oeTj8hvM4s3HJ1Q4StGYHCQXXUeUg@mail.gmail.com
Whole thread Raw
In response to Poor plan when using EXISTS in the expression list  (Pierre Ducroquet <p.psql@pinaraf.info>)
Responses Re: Poor plan when using EXISTS in the expression list  (Pierre Ducroquet <p.psql@pinaraf.info>)
List pgsql-hackers
On Thu, 4 Oct 2018 at 13:11, Pierre Ducroquet <p.psql@pinaraf.info> wrote:
Our developpers ORM (Django's) sadly can not use EXISTS in the where clauses
without having it in the expression part of the SELECT statement.
 
I don't know if this will be helpful to you (and I appreciate there's still the underlying PG issue), but there's a suggestion here that you can work around this using .extra()


Geoff

pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: executor relation handling
Next
From: Alvaro Herrera
Date:
Subject: Re: Multiple primary key on partition table?