]> granicus.if.org Git - postgresql/commit
postgres_fdw: Push down FULL JOINs with restriction clauses.
authorRobert Haas <rhaas@postgresql.org>
Thu, 16 Mar 2017 17:34:59 +0000 (13:34 -0400)
committerRobert Haas <rhaas@postgresql.org>
Thu, 16 Mar 2017 17:34:59 +0000 (13:34 -0400)
commitb30fb56b07a885f3476fe05920249f4832ca8da5
tree9cd61df6b4b83556a935fc52106b958201c17ad7
parenta3eac988c26706059ae74c740a1abcb588449abe
postgres_fdw: Push down FULL JOINs with restriction clauses.

The previous deparsing logic wasn't smart enough to produce subqueries
when deparsing; make it smart enough to do that.  However, we only do
it that way when necessary, because it generates more complicated SQL
which will be harder for any humans reading the queries to understand.

Etsuro Fujita, reviewed by Ashutosh Bapat

Discussion: http://postgr.es/m/c449261a-b033-dc02-9254-2fe5b7044795@lab.ntt.co.jp
contrib/postgres_fdw/deparse.c
contrib/postgres_fdw/expected/postgres_fdw.out
contrib/postgres_fdw/postgres_fdw.c
contrib/postgres_fdw/postgres_fdw.h
contrib/postgres_fdw/sql/postgres_fdw.sql