Re: Getting sorted data from foreign server for merge join

From: Robert Haas <robertmhaas(at)gmail(dot)com>
To: Corey Huinker <corey(dot)huinker(at)gmail(dot)com>
Cc: Ashutosh Bapat <ashutosh(dot)bapat(at)enterprisedb(dot)com>, pgsql-hackers <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: Getting sorted data from foreign server for merge join
Date: 2015-11-09 15:56:57
Message-ID: CA+TgmoYsXH=czHZ7yq2j8DP2Z742gHeLu7VpX_g3-Mg69LLncw@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On Sat, Nov 7, 2015 at 12:07 PM, Corey Huinker <corey(dot)huinker(at)gmail(dot)com> wrote:
> Sorry to barge in late, but I was wondering if what we've learned with this
> patch can be applied to the case of asserting a sort order on a query
> returning from dblink().

Nope.

Sorry to the bearer of bad news, but that would be a different and
much harder development project. Set-returning functions have no way
to indicate anything about the ordering of their return values at
present. We could invent something, but the work involved wouldn't
have much to do with this patch.

--
Robert Haas
EnterpriseDB: http://www.enterprisedb.com
The Enterprise PostgreSQL Company

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Robert Haas 2015-11-09 15:59:38 Re: Getting sorted data from foreign server for merge join
Previous Message Robert Haas 2015-11-09 15:54:04 Re: pgsql: Modify tqueue infrastructure to support transient record types.