postgres_fdw: When sending ORDER BY, always include NULLS FIRST/LAST.
Robert Haas <rhaas@postgresql.org>
postgres_fdw: When sending ORDER BY, always include NULLS FIRST/LAST. Previously, we included NULLS FIRST when appropriate but relied on the default behavior to be NULLS LAST. This is, however, not true for a sort in descending order and seems like a fragile assumption anyway. Report by Rajkumar Raghuwanshi. Patch by Ashutosh Bapat. Review comments from Michael Paquier and Tom Lane.
Files
| Path | Change | +/− |
|---|---|---|
| contrib/postgres_fdw/deparse.c | modified | +2 −0 |
| contrib/postgres_fdw/expected/postgres_fdw.out | modified | +111 −31 |
| contrib/postgres_fdw/sql/postgres_fdw.sql | modified | +12 −0 |