Menu
▾
▴
Re: [Postgres-xc-developers] How to "order by" rows obtained by RETURNING clause
|
From: 鈴木 幸市 <ko...@in...> - 2014-02-12 09:33:49
|
How about SELECT * FROM (UPDATE ,,,, RETURNING *) AS X ORDER BY 1, 2; ? --- Koichi Suzuki 2014/02/12 17:18、Abbas Butt <abb...@en...<mailto:abb...@en...>> のメール： On Wed, Feb 12, 2014 at 12:14 PM, Koichi Suzuki <koi...@gm...<mailto: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...<mailto:Pos...@li...> https://lists.sourceforge.net/lists/listinfo/postgres-xc-developers -- -- Abbas Architect Ph: 92.334.5100153 Skype ID: gabbasb www.enterprisedb.co<http://www.enterprisedb.com/>m<http://www.enterprisedb.com/> Follow us on Twitter @EnterpriseDB Visit EnterpriseDB for tutorials, webinars, whitepapers<http://www.enterprisedb.com/resources-community> and more<http://www.enterprisedb.com/resources-community> ------------------------------------------------------------------------------ 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 |
