Re: [Postgres-xc-developers] How to "order by" rows obtained by RETURNING clause

[Koichi S. <koi...@gm...>]

It is just to maintain the order of rows and there are no other
intention.   It is just like adding ORDER BY clause, NUM NODES OFF and
NODES OFF to maintain .out identical.

RETURNING clause reports rows but the order may vary occasionally,
unlike vanilla PG.   We need a means to maintain the row order in such
a case.

Regards;
---
Koichi Suzuki


2014-02-12 18:48 GMT+09:00 Ashutosh Bapat <ash...@en...>:
> Hi
> Just a note, while changing the testcases like this, please make sure that
> the original intention of the testcase is not challenged. Can you please
> paste some examples?
>
>
> On Wed, Feb 12, 2014 at 3:03 PM, 鈴木 幸市 <ko...@in...> wrote:
>>
>> How about SELECT * FROM (UPDATE ,,,, RETURNING *) AS X ORDER BY 1, 2; ?
>> ---
>> Koichi Suzuki
>>
>> 2014/02/12 17:18、Abbas Butt <abb...@en...> のメール：
>>
>>
>>
>>
>> On Wed, Feb 12, 2014 at 12:14 PM, Koichi Suzuki <koi...@gm...>
>> wrote:
>>>
>>> I'm doing XC 1.2 release to fix regression more robust.
>>>
>>> I found RETURNING clause occasionally reruns rows in different order.
>>>   It is what we should expect but is not good because regression
>>> fails.
>>>
>>> Does anybody know how to order rows from RETURNING clause?
>>
>>
>> Yes, you can use WITH e.g.
>>
>> with t as
>> (
>>   insert into rep_foo values(3,4), (5,6), (7,8)
>>   returning b, a, b, b, b+a, b-a, ctid
>> ) select * from t order by 1, 2;
>>
>> We have used this technique in xc_returning.sql
>>
>>>
>>>
>>> Regards;
>>> ---
>>> Koichi Suzuki
>>>
>>>
>>> ------------------------------------------------------------------------------
>>> Android apps run on BlackBerry 10
>>> Introducing the new BlackBerry 10.2.1 Runtime for Android apps.
>>> Now with support for Jelly Bean, Bluetooth, Mapview and more.
>>> Get your Android app in front of a whole new audience.  Start now.
>>>
>>> http://pubads.g.doubleclick.net/gampad/clk?id=124407151&iu=/4140/ostg.clktrk
>>> _______________________________________________
>>> Postgres-xc-developers mailing list
>>> Pos...@li...
>>> https://lists.sourceforge.net/lists/listinfo/postgres-xc-developers
>>
>>
>>
>>
>> --
>> --
>> Abbas
>> Architect
>>
>> Ph: 92.334.5100153
>> Skype ID: gabbasb
>> www.enterprisedb.com
>>
>> Follow us on Twitter
>> @EnterpriseDB
>>
>> Visit EnterpriseDB for tutorials, webinars, whitepapers and more
>>
>> ------------------------------------------------------------------------------
>> Android apps run on BlackBerry 10
>> Introducing the new BlackBerry 10.2.1 Runtime for Android apps.
>> Now with support for Jelly Bean, Bluetooth, Mapview and more.
>> Get your Android app in front of a whole new audience.  Start now.
>>
>> http://pubads.g.doubleclick.net/gampad/clk?id=124407151&iu=/4140/ostg.clktrk_______________________________________________
>> Postgres-xc-developers mailing list
>> Pos...@li...
>> https://lists.sourceforge.net/lists/listinfo/postgres-xc-developers
>>
>>
>>
>>
>> ------------------------------------------------------------------------------
>> Android apps run on BlackBerry 10
>> Introducing the new BlackBerry 10.2.1 Runtime for Android apps.
>> Now with support for Jelly Bean, Bluetooth, Mapview and more.
>> Get your Android app in front of a whole new audience.  Start now.
>>
>> http://pubads.g.doubleclick.net/gampad/clk?id=124407151&iu=/4140/ostg.clktrk
>> _______________________________________________
>> Postgres-xc-developers mailing list
>> Pos...@li...
>> https://lists.sourceforge.net/lists/listinfo/postgres-xc-developers
>>
>
>
>
> --
> Best Wishes,
> Ashutosh Bapat
> EnterpriseDB Corporation
> The Postgres Database Company
>
> ------------------------------------------------------------------------------
> Android apps run on BlackBerry 10
> Introducing the new BlackBerry 10.2.1 Runtime for Android apps.
> Now with support for Jelly Bean, Bluetooth, Mapview and more.
> Get your Android app in front of a whole new audience.  Start now.
> http://pubads.g.doubleclick.net/gampad/clk?id=124407151&iu=/4140/ostg.clktrk
> _______________________________________________
> Postgres-xc-developers mailing list
> Pos...@li...
> https://lists.sourceforge.net/lists/listinfo/postgres-xc-developers
>