Received: from maia.hub.org (maia-5.hub.org [200.46.204.29]) by mail.postgresql.org (Postfix) with ESMTP id 4DF141337B34 for ; Mon, 31 Jan 2011 06:22:32 -0400 (AST) Received: from mail.postgresql.org ([200.46.204.86]) by maia.hub.org (mx1.hub.org [200.46.204.29]) (amavisd-maia, port 10024) with ESMTP id 05333-05 for ; Mon, 31 Jan 2011 10:22:26 +0000 (UTC) X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 Received: from mail.scanlab.de (mail.scanlab.de [62.138.55.241]) by mail.postgresql.org (Postfix) with ESMTP id 7A1871337999 for ; Mon, 31 Jan 2011 06:22:24 -0400 (AST) Received: from unknown (HELO Exchange-Server.scanlab-intern.de) ([172.16.20.15]) by mail.scanlab-intern.de with ESMTP; 31 Jan 2011 11:22:23 +0100 Received: from Exchange-Server.scanlab-intern.de ([127.0.0.1]) by Exchange-Server ([127.0.0.1]) with mapi; Mon, 31 Jan 2011 11:22:23 +0100 From: Andreas Gaab To: "pgsql-sql@postgresql.org" Date: Mon, 31 Jan 2011 11:22:23 +0100 Subject: Re: aggregation of setof Thread-Topic: [SQL] aggregation of setof Thread-Index: AcvBKLAAvmoDTGgvQgaMhWupwpBX+wABw6iA Message-ID: <48DA836F3865C54B8FBF424A3B775AF6671A6838F9@Exchange-Server> References: <48DA836F3865C54B8FBF424A3B775AF60132434B4A@Exchange-Server> <48DA836F3865C54B8FBF424A3B775AF6671A6838F8@Exchange-Server> In-Reply-To: Accept-Language: de-DE Content-Language: de-DE X-MS-Has-Attach: X-MS-TNEF-Correlator: acceptlanguage: de-DE Content-Type: text/plain; charset="utf-8" Content-Transfer-Encoding: base64 MIME-Version: 1.0 X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=-1.91 tagged_above=-5 required=5 tests=BAYES_00=-1.9, T_RP_MATCHES_RCVD=-0.01 X-Spam-Level: X-Archive-Number: 201101/119 X-Sequence-Number: 35066 SGksDQoNCkNvdWxkIG5vdCB0aGUgZnVuY3Rpb24gcmVnZXhwX21hdGNoZXModGV4dCwgdGV4dCkg YmUgZGVmaW5lZCB0byBvbmx5IHJldHVybiBhIHRleHRbXSBub3QgYSBzZXRvZiB0ZXh0W10/DQoN CkJlY2F1c2UgdGhhdCBpcywgd2hhdCBpdCBhY3R1YWxseSBkb2VzLCBvcj8gRm9yIGV2ZXJ5IGlu cHV0LCBpdCByZXR1cm5zIG9ubHkgb25lIG91dHB1dCByb3cuIFRoZSBmdW5jdGlvbiByZWdleHBf bWF0Y2hlcyh0ZXh0LHRleHQsdGV4dCkgaW4gY29udHJhc3QgcmVhbGx5IGNhbiByZXR1cm4gbXVs dGlwbGUgcm93cyB3aGlsZSBvbmx5IHJlY2VpdmluZyBvbmUgcm93Lg0KDQoNClJlZ2FyZHMsDQpB bmRyZWFzDQoNCg0KLS0tLS1VcnNwcsO8bmdsaWNoZSBOYWNocmljaHQtLS0tLQ0KVm9uOiBQYXZl bCBTdGVodWxlIFttYWlsdG86cGF2ZWwuc3RlaHVsZUBnbWFpbC5jb21dIA0KR2VzZW5kZXQ6IE1v bnRhZywgMzEuIEphbnVhciAyMDExIDEwOjI0DQpBbjogQW5kcmVhcyBHYWFiDQpDYzogcGdzcWwt c3FsQHBvc3RncmVzcWwub3JnDQpCZXRyZWZmOiBSZTogW1NRTF0gYWdncmVnYXRpb24gb2Ygc2V0 b2YNCg0KSGVsbG8NCg0KdXNlIGEgYXJyYXkgY29uc3RydWN0b3IgaW5zdGVhZA0KDQpTRUxFQ1Qg QVJSQVkoU0VMRUNUIC4uLikNCg0KUmVnYXJkcw0KDQpQYXZlbCBTdGVodWxlDQoNCjIwMTEvMS8z MSBBbmRyZWFzIEdhYWIgPEEuR2FhYkBzY2FubGFiLmRlPjoNCj4gRnVuY3Rpb25zIGFwcGFyZW50 bHkgY2Fubm90IHRha2Ugc2V0b2YgYXJndW1lbnRzLg0KPg0KPg0KPg0KPiBQb3N0Z3JlcyA4LjQ6 DQo+DQo+DQo+DQo+IENSRUFURSBPUiBSRVBMQUNFIEZVTkNUSU9OIHRlc3R0YWJsZShJTiBzZXRv ZiBhbnlhcnJheSkNCj4NCj4gwqAgUkVUVVJOUyBhbnlhcnJheSBBUw0KPg0KPiAkQk9EWSQNCj4N Cj4gU0VMRUNUICQxIExJTUlUIDE7DQo+DQo+ICRCT0RZJA0KPg0KPiDCoCBMQU5HVUFHRSAnc3Fs JyBTVEFCTEU7DQo+DQo+DQo+DQo+IMOgDQo+DQo+IEVSUk9SOsKgIGZ1bmN0aW9ucyBjYW5ub3Qg YWNjZXB0IHNldCBhcmd1bWVudHMNCj4NCj4NCj4NCj4NCj4NCj4NCj4NCj4gVm9uOiBWaWt0b3Ig Qm9qb3ZpxIcgW21haWx0bzp2aWt0b3IuYm9qb3ZpY0BnbWFpbC5jb21dDQo+IEdlc2VuZGV0OiBT YW1zdGFnLCAyOS4gSmFudWFyIDIwMTEgMDk6MjgNCj4gQW46IEFuZHJlYXMgR2FhYg0KPiBCZXRy ZWZmOiBSZTogW1NRTF0gYWdncmVnYXRpb24gb2Ygc2V0b2YNCj4NCj4NCj4NCj4gaSBoYXZlIG5l dmVyIHVzZWQgdGhhdCB0eXBlIGJ1dCBtYXliZSB5b3UgY2FuIHRyeSB0aGlzOw0KPg0KPiAtY3Jl YXRlIGZ1bmN0aW9uIHdoaWNoIHJldHVybnMgdGV4dFtdLCBhbmQgdGFrc2Ugc2V0b2YgdGV4dCBh cyBhcmd1bWVudCAoaWYNCj4gcG9zc2libGUpDQo+DQo+IC1yZWFjaCBldmVyeSB0ZXh0W10gaW4g c2V0IG9mIHRleHRbXSB1c2luZyBhcnJheSBpbmRleA0KPg0KPiAtcmV0dXJuIHZhbHVlcyB1c2lu ZyAicmV0dXJuIG5leHQiIGZvciBlYWNoIHRleHQgaW4gdGV4dFtdIHdoaWNoIGlzIGluIHNldA0K PiBvZiB0ZXh0W10NCj4NCj4NCj4NCj4gT24gRnJpLCBKYW4gMjgsIDIwMTEgYXQgMTI6NDIgUE0s IEFuZHJlYXMgR2FhYiA8QS5HYWFiQHNjYW5sYWIuZGU+IHdyb3RlOg0KPg0KPiBIaSBhbGwsDQo+ DQo+DQo+DQo+IEkgd291bGQgbGlrZSB0byB3cml0ZSBhIHF1ZXJ5LCB3aGljaCBhZ2dyZWdhdGVz IHRoZSByZXN1bHRzIG9mDQo+IHJlZ2V4cF9tYXRjaGVzKCkuIFRoZSBwcm9ibGVtIGlzIHRoYXQg cmVnZXhwX21hdGNoZXMgcmV0dXJuZXMgc2V0b2YgdGV4dFtdDQo+IGFzIGRvY3VtZW50ZWQgZXZl biBpZiBJIGRpc2NhcmQgdGhlIGdsb2JhbCBmbGFnDQo+IChodHRwOi8vd3d3LnBvc3RncmVzcWwu b3JnL2RvY3MvOC40L3N0YXRpYy9mdW5jdGlvbnMtbWF0Y2hpbmcuaHRtbCNGVU5DVElPTlMtUE9T SVgtUkVHRVhQDQo+ICkuIFRodXMgcmVzdWx0aW5nIGluIGFuIGVycm9yIHdoZW4gSSB0cnkgdG8g YWdncmVnYXRlIHRoZSByZXN1bHQ6DQo+DQo+DQo+DQo+IOKAnA0KPg0KPiBTRUxFQ1QgYXJyYXlf YWNjdW0oDQo+DQo+IHJlZ2V4cF9tYXRjaGVzKCdmb29iYXJiZXF1ZWJhemlsYmFyZmJvbmsnLCAn KGJbXmJdKykoYlteYl0rKScpDQo+DQo+ICkNCj4NCj4gLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0t LS0tLS0tLQ0KPg0KPiBFUlJPUjrCoCBzZXQtdmFsdWVkIGZ1bmN0aW9uIGNhbGxlZCBpbiBjb250 ZXh0IHRoYXQgY2Fubm90IGFjY2VwdCBhIHNldA0KPg0KPiAqKioqKioqKioqIEZlaGxlciAqKioq KioqKioqDQo+DQo+IEVSUk9SOiBzZXQtdmFsdWVkIGZ1bmN0aW9uIGNhbGxlZCBpbiBjb250ZXh0 IHRoYXQgY2Fubm90IGFjY2VwdCBhIHNldA0KPg0KPiBTUUwgU3RhdHVzOjBBMDAwDQo+DQo+IOKA nA0KPg0KPg0KPg0KPiBDYW4gSSBjb252ZXJ0IGEg4oCac2V0b2YgdGV4dFtd4oCYIHRvIGEg4oCa dGV4dFtd4oCYPw0KPg0KPg0KPg0KPiBBbHRlcm5hdGl2ZWx5IEkgY291bGQgdXNlIGEgc3ViLXNl bGVjdCwgYnV0IEkgYW0gY3VyaW91cyBpZiB0aGVyZSBhcmUgb3RoZXINCj4gc29sdXRpb25zIGFy b3VuZC4NCj4NCj4NCj4NCj4gUmVnYXJkcywNCj4NCj4gQW5kcmVhcw0KPg0KPg0KPg0KPiBfX19f X19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19f X19fX19fX19fX19fX18NCj4NCj4NCj4NCj4gU0NBTkxBQsKgQUcNCj4NCj4gRHIuwqBBbmRyZWFz wqBTaW1vbsKgR2FhYg0KPg0KPiBFbnR3aWNrbHVuZyDigKIgUsKgJsKgRA0KPg0KPg0KPg0KPiBT aWVtZW5zc3RyLsKgMmEg4oCiIDgyMTc4wqBQdWNoaGVpbSDigKIgR2VybWFueQ0KPg0KPiBUZWwu wqArNDnCoCg4OSnCoDgwMMKgNzQ2LTUxMyDigKIgRmF4wqArNDnCoCg4OSnCoDgwMMKgNzQ2LTE5 OQ0KPg0KPiBtYWlsdG86YS5nYWFiQHNjYW5sYWIuZGUg4oCiIHd3dy5zY2FubGFiLmRlDQo+DQo+ DQo+DQo+IEFtdHNnZXJpY2h0wqBNw7xuY2hlbjogSFJCwqAxMjQ3MDcg4oCiIFVTdC1JZE5yLjog REXCoDEyOcKgNDU2wqAzNTENCj4NCj4gVm9yc3RhbmQ6IEdlb3JnwqBIb2ZuZXLCoChTcHJlY2hl ciksIENocmlzdGlhbsKgSHV0dGVubG9oZXIsIE5vcmJlcnTCoFBldHNjaGlrDQo+DQo+IEF1ZnNp Y2h0c3JhdMKgKFZvcnNpdHopOiBEci7CoEhhbnPCoEouwqBMYW5nZXINCj4NCj4gX19fX19fX19f X19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19f X19fX19fX19fDQo+DQo+DQo+DQo+DQo+IC0tDQo+IC0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0t LS0tLS0tLS0tLS0tLQ0KPiBWaWt0b3IgQm9qb3ZpxIcNCj4gLS0tLS0tLS0tLS0tLS0tLS0tLS0t LS0tLS0tLS0tLS0tLS0tLS0tDQo+IFdoZXJldmVyIEkgZ28sIE11cnBoeSBnb2VzIHdpdGggbWUN Cg==