Re: BUG #10972: string_agg function incorrectly concatenating varying delimiter
| От | Jeff Fischer |
|---|---|
| Тема | Re: BUG #10972: string_agg function incorrectly concatenating varying delimiter |
| Дата | |
| Msg-id | A9E08E7AD090E449A9A4DE22199AB4D9D432ED51@EXMBX09.netplexity.local обсуждение исходный текст |
| Ответ на | Re: BUG #10972: string_agg function incorrectly concatenating varying delimiter (Pavel Stehule <pavel.stehule@gmail.com>) |
| Список | pgsql-bugs |
VGhhbmsgeW91IHZlcnkgbXVjaCBQYXZlbC4NCg0KVGhhbmtzLA0KSmVmZg0KDQpGcm9tOiBQYXZl bCBTdGVodWxlIFttYWlsdG86cGF2ZWwuc3RlaHVsZUBnbWFpbC5jb21dDQpTZW50OiBNb25kYXks IEp1bHkgMjEsIDIwMTQgMTA6NDIgUE0NClRvOiBKZWZmIEZpc2NoZXINCkNjOiBUb20gTGFuZTsg cGdzcWwtYnVnc0Bwb3N0Z3Jlc3FsLm9yZzsgRGF2ZSBZYXJuYWxsDQpTdWJqZWN0OiBSZTogW0JV R1NdIEJVRyAjMTA5NzI6IHN0cmluZ19hZ2cgZnVuY3Rpb24gaW5jb3JyZWN0bHkgY29uY2F0ZW5h dGluZyB2YXJ5aW5nIGRlbGltaXRlcg0KDQpIZWxsbw0KDQoyMDE0LTA3LTIxIDIyOjM0IEdNVCsw MjowMCBKZWZmIEZpc2NoZXIgPGplZmZAZ29hbGRyaXZlbi5jb208bWFpbHRvOmplZmZAZ29hbGRy aXZlbi5jb20+PjoNCkhpIFRvbSwNCg0KSSBqdXN0IHJlYWQgdGhlIFdpa2lwZWRpYSBhcnRpY2xl IG9uIHlvdSwgZnVuLiAgR2xhZCB0byBtYWtlIHlvdXIgYWNxdWFpbnRhbmNlLiAgTXkgYnVzaW5l c3MgcGFydG5lciwgRGF2ZSBZYXJuYWxsLCB3ZW50IHRvIENhcm5lZ2llIE1lbGxvbiAoQ0NlZCku DQoNCkkgc3VwcG9zZSBwcmluY2lwbGVzIGNhbiBiZSByZWxhdGl2ZSwgYnV0IEknbGwgYXNzdW1l IHlvdSBtZWFuIGdvb2QgcHJpbmNpcGxlcyBhbmQgZ2l2ZSBpdCBhIHNob3QuDQoNClByaW1hcmls eSwgSSdkIGNvbnNpZGVyIHdoZXRoZXIgYW5vdGhlciBmdW5jdGlvbiB1c2VzIG5vbi1kZXRlcm1p bmlzdGljIHJvd3MgZm9yIGl0cyBldmFsdWF0aW9uLiAgSSBjb3VsZCBiZSB3cm9uZywgYnV0IEkg ZG9uJ3QgdGhpbmsgYW55IG90aGVyIGZ1bmN0aW9uIHVzZXMgdHdvIGRpZmZlcmVudCByb3dzIHJl c3VsdHMgd2l0aGluIGEgc2luZ2xlIGZ1bmN0aW9uIGV2YWx1YXRpb24uICBFdmVuIGFnZ3JlZ2F0 ZXMsIHN1Y2ggYXMgc3RyaW5nX2FnZywgZXZhbHVhdGUgb25lIHJvdyBhdCBhIHRpbWUgd2hpY2gg aXMgYSB3ZWxsLWtub3duIGJlaGF2aW9yLg0KDQpBIHNpbWlsYXIgcGFyYWRpZ20gbWlnaHQgYmUg aW4gZ2VuZXJhbCBwcm9ncmFtbWluZyBpZiBhIGNvbXBpbGVkIHByb2dyYW0gcmFuZG9tbHkgY2hv c2UgdmFsdWVzIG9mZiBvZiB0aGUgc3RhY2sgdG8gcGxhY2UgYXMgYSBwYXJhbWV0ZXIgaW50byBh IG1ldGhvZCBjYWxsIChmdW5jdGlvbiAzJ3MgcGFyYW1ldGVycyBhcmUgcGFzc2VkIGludG8gZnVu Y3Rpb24yKS4gIEFuIG9kZCBhbmQgdW5leHBlY3RlZCBiZWhhdmlvciBmb3IgdGhlIFNRTCBsYW5n dWFnZSBhbmQgcmVhbGx5IGFueSBsYW5ndWFnZSwgSSB0aGluay4gIEFsdGhvdWdoLCBpdCBpcyBx dWl0ZSBjcmVhdGl2ZS4NCg0KSXQgc291bmRzIGxpa2UgeW91J3ZlIHF1aWNrbHkgaXNvbGF0ZWQg dGhlIGxpbmUgd2l0aGluIHRoZSBzb3VyY2UuICBJbiBhbiBpbnRlcmVzdCBpbiBsZWFybmluZyBt b3JlIGFib3V0IHRoZSBjb2RlLCB3b3VsZCB5b3UgbWluZCBwb2ludGluZyBteSBwYXJ0bmVyIGFu ZCBJIHRvIHRoZSBsaW5lIGZvciB0aGlzIGJ1Zz8NCg0KaHR0cHM6Ly9naXRodWIuY29tL3Bvc3Rn cmVzL3Bvc3RncmVzL2Jsb2IvbWFzdGVyL3NyYy9iYWNrZW5kL3V0aWxzL2FkdC92YXJsZW5hLmMN CnNlYXJjaCBzdHJpbmdfYWdnDQoNClJlZ2FyZHMNClBhdmVsDQoNCg0KVGhhbmtzLA0KSmVmZg0K DQotLS0tLU9yaWdpbmFsIE1lc3NhZ2UtLS0tLQ0KRnJvbTogVG9tIExhbmUgW21haWx0bzp0Z2xA c3NzLnBnaC5wYS51czxtYWlsdG86dGdsQHNzcy5wZ2gucGEudXM+XQ0KU2VudDogV2VkbmVzZGF5 LCBKdWx5IDE2LCAyMDE0IDc6MjAgQU0NClRvOiBKZWZmIEZpc2NoZXINCkNjOiBwZ3NxbC1idWdz QHBvc3RncmVzcWwub3JnPG1haWx0bzpwZ3NxbC1idWdzQHBvc3RncmVzcWwub3JnPg0KU3ViamVj dDogUmU6IFtCVUdTXSBCVUcgIzEwOTcyOiBzdHJpbmdfYWdnIGZ1bmN0aW9uIGluY29ycmVjdGx5 IGNvbmNhdGVuYXRpbmcgdmFyeWluZyBkZWxpbWl0ZXINCg0KamVmZkBnb2FsZHJpdmVuLmNvbTxt YWlsdG86amVmZkBnb2FsZHJpdmVuLmNvbT4gd3JpdGVzOg0KPiBSdW5uaW5nIHRoZSBxdWVyeSBi ZWxvdyB3aWxsIHNob3cgaG93IHRoZSBkZWxpbWl0ZXIgZm9yIHRoZSBjdXJyZW50DQo+IHJvdyBp cyBhY3R1YWxseSB0aGUgc3Vic2VxdWVudCByb3dzIGRlbGltaXRlci4NCg0KSG1tLCB3ZWxsLCB0 aGUgZG9jdW1lbnRhdGlvbiBmb3Igc3RyaW5nX2FnZyBkb2Vzbid0IHNheSB3aGF0IGhhcHBlbnMg d2hlbiB0aGUgImRlbGltaXRlciIgYXJndW1lbnQgdmFyaWVzIGFjcm9zcyByb3dzOyBidXQgYSBx dWljayBsb29rIGF0IHRoZSBjb2RlIGZpbmRzIHRoYXQgdGhlIGZpcnN0LWNhbGwgZGVsaW1pdGVy IGlzbid0IGFjdHVhbGx5IHVzZWQgYXQgYWxsLCBhbmQgb24gc3Vic2VxdWVudCBjYWxscyB0aGUg ZGVsaW1pdGVyIGlzIGFwcGVuZGVkIHRvIHRoZSBydW5uaW5nIHJlc3VsdCBiZWZvcmUgdGhlIGFz c29jaWF0ZWQgdmFsdWUgaXMuICBXaGljaCBzZWVtcyB0byBtZSB0byBiZSBhdCBsZWFzdCBhcyBy ZWFzb25hYmxlLCBhbmQgY2VydGFpbmx5IGEgZ3JlYXQgZGVhbCBlYXNpZXIgdG8gaW1wbGVtZW50 LCBhcyB3aGF0IHlvdSBzZWVtIHRvIGhhdmUgaW4gbWluZC4gIENhbiB5b3Ugb2ZmZXIgYSBwcmlu Y2lwbGVkIGFyZ3VtZW50IHdoeSBpdCBzaG91bGQgYmUgdGhlIG90aGVyIHdheSBhcm91bmQ/DQoN CiAgICAgICAgICAgICAgICAgICAgICAgIHJlZ2FyZHMsIHRvbSBsYW5lDQoNCg0KLS0NClNlbnQg dmlhIHBnc3FsLWJ1Z3MgbWFpbGluZyBsaXN0IChwZ3NxbC1idWdzQHBvc3RncmVzcWwub3JnPG1h aWx0bzpwZ3NxbC1idWdzQHBvc3RncmVzcWwub3JnPikNClRvIG1ha2UgY2hhbmdlcyB0byB5b3Vy IHN1YnNjcmlwdGlvbjoNCmh0dHA6Ly93d3cucG9zdGdyZXNxbC5vcmcvbWFpbHByZWYvcGdzcWwt YnVncw0KDQo=
В списке pgsql-bugs по дате отправления: