Postgres Pro
Downloads
Home   >   mailing lists

Pull up sublink of type 'NOT NOT (expr)' - Mailing list pgsql-hackers

From Richard Guo
Subject Pull up sublink of type 'NOT NOT (expr)'
Date
Msg-id CAN_9JTxpgxnTa_EPvmfuy6vogY0smQmYbEvbJhx=bD1iAjK5BQ@mail.gmail.com
Whole thread Raw
Responses Re: Pull up sublink of type 'NOT NOT (expr)'  (Alexey Bashtanov <bashtanov@imap.cc>)
Re: Pull up sublink of type 'NOT NOT (expr)'  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-hackers
Tree view
Hi hackers,

Currently for quals in the form of "NOT NOT (SubLink)", this SubLink would not
be considered when pulling up sublinks. For instance:

gpadmin=# explain select * from a where NOT NOT (a.i in (select b.i from b));
                         QUERY PLAN
-------------------------------------------------------------
 Seq Scan on a  (cost=51.50..85.62 rows=1005 width=8)
   Filter: (hashed SubPlan 1)
   SubPlan 1
     ->  Seq Scan on b  (cost=0.00..44.00 rows=3000 width=4)
(4 rows)


Should we give it a chance, like the attached does?

Thanks
Richard
Attachment

pgsql-hackers by date:

Previous
From: Victor Wagner
Date:
Subject: Building 64-bit postgres with GSS support on windows
Next
From: Victor Wagner
Date:
Subject: Perl 5.26 and windows build system