Received: from maia.hub.org (maia-5.hub.org [200.46.204.29]) by mail.postgresql.org (Postfix) with ESMTP id C8FBF6333B9 for ; Tue, 7 Sep 2010 09:29:25 -0300 (ADT) 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 27723-01 for ; Tue, 7 Sep 2010 12:29:18 +0000 (UTC) X-Greylist: delayed 00:09:54.885664 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 2D7CF63497A for ; Tue, 7 Sep 2010 09:29:17 -0300 (ADT) Received: from unknown (HELO Exchange-Server.scanlab-intern.de) ([172.16.20.15]) by mail.scanlab-intern.de with ESMTP; 07 Sep 2010 14:19:20 +0200 Received: from Exchange-Server.scanlab-intern.de ([127.0.0.1]) by Exchange-Server ([127.0.0.1]) with mapi; Tue, 7 Sep 2010 14:19:20 +0200 From: Andreas Gaab To: "pgsql-sql@postgresql.org" Date: Tue, 7 Sep 2010 14:19:19 +0200 Subject: Re: is there a distinct function for comma lists ? Thread-Topic: [SQL] is there a distinct function for comma lists ? Thread-Index: ActOgxAwGgcyQJM9QFSlL9zZSD411gAA4u/w Message-ID: <48DA836F3865C54B8FBF424A3B775AF6011D0A5EC1@Exchange-Server> References: <4C862773.2070900@gmx.net> In-Reply-To: <4C862773.2070900@gmx.net> 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: 201009/13 X-Sequence-Number: 34544 SGksDQoNCkZvciB0aGUgcHJvYmxlbSAxIHBlcmhhcHMgc29tZXRoaW5nIGxpa2UNCg0Kc2VsZWN0 IGRpc3RpbmN0IHVubmVzdChBUlJBWVsgMSwgMiwgMywgNSwgNywgMTEsIDMsIDYsIDEzLCAxMywg MywgMTEgXSkNCg0KUmVnYXJkcywNCkFuZHJlYXMNCg0KLS0tLS1VcnNwcsO8bmdsaWNoZSBOYWNo cmljaHQtLS0tLQ0KVm9uOiBwZ3NxbC1zcWwtb3duZXJAcG9zdGdyZXNxbC5vcmcgW21haWx0bzpw Z3NxbC1zcWwtb3duZXJAcG9zdGdyZXNxbC5vcmddIEltIEF1ZnRyYWcgdm9uIEFuZHJlYXMNCkdl c2VuZGV0OiBEaWVuc3RhZywgNy4gU2VwdGVtYmVyIDIwMTAgMTM6NTINCkFuOiBwZ3NxbC1zcWxA cG9zdGdyZXNxbC5vcmcNCkJldHJlZmY6IFtTUUxdIGlzIHRoZXJlIGEgZGlzdGluY3QgZnVuY3Rp b24gZm9yIGNvbW1hIGxpc3RzID8NCg0KICBIaSwNCmlzIHRoZXJlIGEgZGlzdGluY3QgZnVuY3Rp b24gZm9yIGNvbW1hIHNlcGFyYXRlZCBsaXN0cyA/DQoNCkkgc29tZXRpbWVzIG5lZWQgdG8gdXBk YXRlIHRhYmxlcyB3aGVyZSBJIGdvdCBhIHNldCBvZiBJRHMsIGxpa2U6DQoNCnVwZGF0ZSBteXRh YmxlDQogICAgc2V0IHNvbWVhdHRyaWJ1dGUgPSA0Mg0Kd2hlcmUgbXl0YWJsZS5pZCBpbg0KKCAg MSwgMiwgMywgNSwgNywgMTEsIDMsIDYsIDEzLCAxMywgMywgMTEgLi4uICkNCg0KU28gdGhlcmUg YXJlIGRvdWJsZSBlbnRyaWVzIGluIHRoZSBsaXN0IGJ1dCBpbiB0aGlzIGNhc2UgaXRzIGp1c3Qg DQpvdmVyaGVhZCBidXQgbm8gcHJvYmxlbS4NCg0KQnV0IGZvciBjYWxjdWxhdGVkIHZhbHVlcyB0 aGlzIHdvdWxkIG5vdCBhbGx3YXlzIGJlIGRlc2lyYWJsZS4NCg0KdXBkYXRlIG15dGFibGUNCiAg ICBzZXQgc29tZWF0dHJpYnV0ZSA9IHNvbWVhdHRyaWJ1dGUgKyAxDQp3aGVyZSBteXRhYmxlLmlk IGluDQooICAxLCAyLCAzLCA1LCA3LCAxMSwgMywgNiwgMTMsIDEzLCAzLCAxMSAuLi4gKQ0KDQpI b3cgY291bGQgSSBnZXQgYSBkaXN0aW5jdCBsaXN0PyBUaG9zZSBsaXN0cyBjYW4gaGF2ZSAyMDAw LTMwMDAgSURzIA0Kc29tZXRpbWVzLg0KDQpPbmUgc29sdXRpb24gd2FzIGFzIGZvbGxvd3MgYnV0 IHBlcmhhcHMgdGhlcmUgaXMgc29tZXRoaW5nIG1vcmUgZWxlZ2FudD8NCg0KdXBkYXRlIG15dGFi bGUNCiAgICBzZXQgc29tZWF0dHJpYnV0ZSA9IHNvbWVhdHRyaWJ1dGUgKyAxDQp3aGVyZSBteXRh YmxlLmlkIGluDQogICggc2VsZWN0IGRpc3RpbmN0IGlkIGZyb20gbXl0YWJsZSB3aGVyZSBpZCBp biAoICAxLCAyLCAzLCA1LCA3LCAxMSwgMywgDQo2LCAxMywgMTMsIDMsIDExIC4uLiApICkNCg0K DQpBbmQgYXMgYm9udXMgLi4uIGlzIHRoZXJlIGEgd2F5IHRvIGZpbmQgSURzIHRoYXQgYXJlIGlu IHRoZSBsaXN0IGJ1dCBub3QgDQppbiB0aGUgdGFibGUgd2l0aG91dCBjcmVhdGluZyBhIHRlbXBv cmFyeSB0YWJsZSBhbmQgdXNlIGEgam9pbj8NCg0KLS0gDQpTZW50IHZpYSBwZ3NxbC1zcWwgbWFp bGluZyBsaXN0IChwZ3NxbC1zcWxAcG9zdGdyZXNxbC5vcmcpDQpUbyBtYWtlIGNoYW5nZXMgdG8g eW91ciBzdWJzY3JpcHRpb246DQpodHRwOi8vd3d3LnBvc3RncmVzcWwub3JnL21haWxwcmVmL3Bn c3FsLXNxbA0K