]> granicus.if.org Git - postgresql/commit
postgres_fdw: Consider foreign joining and foreign sorting together.
authorRobert Haas <rhaas@postgresql.org>
Wed, 9 Mar 2016 15:51:49 +0000 (10:51 -0500)
committerRobert Haas <rhaas@postgresql.org>
Wed, 9 Mar 2016 15:51:49 +0000 (10:51 -0500)
commitaa09cd242fa7e3a694a31f8aed521e80d1e626a4
treef59e3056c8fc5d461c89e906a5aa74eb167ff926
parentd31f20e2b5a246f276c73134b610ac7a2f34e274
postgres_fdw: Consider foreign joining and foreign sorting together.

Commit ccd8f97922944566d26c7d90eb67ab7848ee9905 gave us the ability to
request that the remote side sort the data, and, later, commit
e4106b2528727c4b48639c0e12bf2f70a766b910 gave us the ability to
request that the remote side perform the join for us rather than doing
it locally.  But we could not do both things at the same time: a
remote SQL query that had an ORDER BY clause would never be a join.
This commit adds that capability.

Ashutosh Bapat, reviewed by me.
contrib/postgres_fdw/expected/postgres_fdw.out
contrib/postgres_fdw/postgres_fdw.c
contrib/postgres_fdw/sql/postgres_fdw.sql