[MojoMojo] Re: Postgresql problem with GROUP BY clauses

[Marcus Ramberg]

MS4wMyBpbmNsdWRpbmcgdGhpcyBmaXggaXMgb3V0IG9uIENQQU4gbm93LgoKTWFyY3VzCgoyMDEx
LzEvMTIgTWF0ZXUgWC4gSHVudGVyIDxodW50ZXJAbWlzc291bGEub3JnPgoKPiBIZWxsbywKPgo+
IEkgYmVsaWV2ZSBJIGhhdmUgYSBmaXggZm9yIHRoZSBxdWVyeSBpc3N1ZSB5b3UgZW5jb3VudGVy
ZWQuICBJdCBpcyBwYXJ0IG9mCj4gdGhlIGNvbW1pdCBsaXN0ZWQgYmVsb3c6Cj4KPgo+IGh0dHBz
Oi8vZ2l0aHViLmNvbS9tYXJjdXNyYW1iZXJnL21vam9tb2pvL2NvbW1pdC83NGQwNzc0ZTE4MmVj
ZjI1MThhZmZlYjUzZjNmZTM1NjFlNTNiNzEKPgo+IC0gTWF0ZXUKPgo+Cj4KPiAyMDExLzEvMTEg
bXNjaHVtYW5uIDxtb2pvbW9qb0BoaWRkZW4tcHJpbWFyeS5uZXQ+Cj4KPgo+PiBIaSwKPj4KPj4g
d2hlbiB0aGUgdGVzdCBzY3JpcHQgdC9zY2hlbWFfREJJQ19QYWdlLnQgaXMgdHJpZWQsIGl0IHRo
cm93cyB0aGUKPj4gZXhjZXB0aW9uCj4+IG1lbnRpb25lZCBpbiBteSBmaXJzdCBwb3N0LiBVbmZv
cnR1bmF0ZWx5IGlzIGhhcyB0byBiZSBwYXRjaGVkIHRvIG5vdAo+PiBkZXN0cm95IHRoZSBkYXRh
YmFzZToKPj4KPj4gLS0tIHQvc2NoZW1hX0RCSUNfUGFnZS50Lm9yaWcgICAyMDExLTAxLTAyIDA3
OjUzOjU1LjUyOTQyMTAwMCArMDEwMAo+PiArKysgdC9zY2hlbWFfREJJQ19QYWdlLnQgICAgICAg
IDIwMTEtMDEtMTEgMjE6MTU6MDguMTY2OTIyOTYyICswMTAwCj4+IEBAIC0xNiw3ICsxNiw4IEBA
Cj4+ICB1c2UgbGliICd0L2xpYic7Cj4+ICB1c2UgTW9qb01vam9UZXN0U2NoZW1hOwo+Pgo+PiAt
bXkgJHNjaGVtYSA9IE1vam9Nb2pvVGVzdFNjaGVtYS0+aW5pdF9zY2hlbWEocG9wdWxhdGUgPT4g
MSk7Cj4+ICsjbXkgJHNjaGVtYSA9IE1vam9Nb2pvVGVzdFNjaGVtYS0+aW5pdF9zY2hlbWEocG9w
dWxhdGUgPT4gMSk7Cj4+ICtteSAkc2NoZW1hID0gTW9qb01vam9UZXN0U2NoZW1hLT5nZXRfc2No
ZW1hOwo+Pgo+PiAgbXkgKCRyb290X3BhdGhfcGFnZXMsICRyb290X3Byb3RvX3BhZ2VzKSA9Cj4+
ICRzY2hlbWEtPnJlc3VsdHNldCgnUGFnZScpLT5wYXRoX3BhZ2VzKCcvJyk7Cj4+ICBteSAkcm9v
dF9wYXRoX3BhZ2VzX2NvdW50ID0gQCRyb290X3BhdGhfcGFnZXM7Cj4+Cj4+IFRoZW4gSSBnZXQg
dGhlIHJlc3VsdDoKPj4KPj4gdC9zY2hlbWFfREJJQ19QYWdlLnQgLi4gMS8xMQo+PiAuLi4KPj4g
IyAgIEZhaWxlZCB0ZXN0ICdHb3QgMSB0YWdnZWQgZGVzY2VuZGFudC4nCj4+ICMgICBhdCB0L3Nj
aGVtYV9EQklDX1BhZ2UudCBsaW5lIDYyLgo+PiAjICAgICAgICAgIGdvdDogJzInCj4+ICMgICAg
IGV4cGVjdGVkOiAnMScKPj4gREJJeDo6Q2xhc3M6OlJlc3VsdFNldDo6c2VhcmNoKCk6IERCSSBF
eGNlcHRpb246IERCRDo6UGc6OnN0IGV4ZWN1dGUKPj4gZmFpbGVkOgo+PiBjb2x1bW4gImNvbnRl
bnQuY3JlYXRlZCIgbXVzdCBhcHBlYXIgaW4gdGhlIEdST1VQIEJZIGNsYXVzZSBvciBiZSB1c2Vk
IGluCj4+IGFuCj4+IGFnZ3JlZ2F0ZSBmdW5jdGlvbgo+PiBMSU5FIDE6IC4uLmVwdGgsIG1lLmxm
dCwgbWUucmd0LCBtZS5jb250ZW50X3ZlcnNpb24gT1JERVIgQlkgY29udGVudC5jci4uLgo+PiAg
ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg
ICBeIFtmb3IKPj4gU3RhdGVtZW50ICJTRUxFQ1QgbWUuaWQsIG1lLnZlcnNpb24sIG1lLnBhcmVu
dCwgbWUubmFtZSwgbWUubmFtZV9vcmlnLAo+PiBtZS5kZXB0aCwgbWUubGZ0LCBtZS5yZ3QsIG1l
LmNvbnRlbnRfdmVyc2lvbiBGUk9NIHBhZ2UgYXMgbWUsIHBhZ2UgYXMKPj4gYW5jZXN0b3IsIHRh
ZywgY29udGVudCBXSEVSRSAoICggKCBtZS5pZCA9YW5jZXN0b3IuaWQgT1IgKCBtZS5sZnQgPgo+
PiBhbmNlc3Rvci5sZnQgQU5EIG1lLnJndCA8IGFuY2VzdG9yLnJndCApICkgQU5EIGFuY2VzdG9y
LmlkID0gPyBBTkQKPj4gY29udGVudC5wYWdlID1tZS5pZCBBTkQgY29udGVudC52ZXJzaW9uID1t
ZS5jb250ZW50X3ZlcnNpb24gQU5EIG1lLmlkCj4+ID10YWcucGFnZSBBTkQgdGFnID0gPyApICkg
R1JPVVAgQlkgbWUuaWQsIG1lLnZlcnNpb24sIG1lLnBhcmVudCwgbWUubmFtZSwKPj4gbWUubmFt
ZV9vcmlnLCBtZS5kZXB0aCwgbWUubGZ0LCBtZS5yZ3QsIG1lLmNvbnRlbnRfdmVyc2lvbiBPUkRF
UiBCWQo+PiBjb250ZW50LmNyZWF0ZWQgREVTQyIgd2l0aCBQYXJhbVZhbHVlczogMT0nMScsIDI9
J3Rlc3QnXSBhdAo+PiAuLi4vbGlibW9qb21vam8tcGVybC1kZXZlbC9saWIvTW9qb01vam8vU2No
ZW1hL1Jlc3VsdC9QYWdlLnBtIGxpbmUgMjE5Cj4+ICMgTG9va3MgbGlrZSB5b3UgcGxhbm5lZCAx
MSB0ZXN0cyBidXQgcmFuIDEwLgo+PiAjIExvb2tzIGxpa2UgeW91IGZhaWxlZCAzIHRlc3RzIG9m
IDEwIHJ1bi4KPj4gIyBMb29rcyBsaWtlIHlvdXIgdGVzdCBleGl0ZWQgd2l0aCAyNTUganVzdCBh
ZnRlciAxMC4KPj4gdC9zY2hlbWFfREJJQ19QYWdlLnQgLi4gRHViaW91cywgdGVzdCByZXR1cm5l
ZCAyNTUgKHdzdGF0IDY1MjgwLCAweGZmMDApCj4+IEZhaWxlZCA0LzExIHN1YnRlc3RzCj4+Cj4+
IFRlc3QgU3VtbWFyeSBSZXBvcnQKPj4gLS0tLS0tLS0tLS0tLS0tLS0tLQo+PiB0L3NjaGVtYV9E
QklDX1BhZ2UudCAoV3N0YXQ6IDY1MjgwIFRlc3RzOiAxMCBGYWlsZWQ6IDMpCj4+ICBGYWlsZWQg
dGVzdHM6ICA0LTUsIDkKPj4gIE5vbi16ZXJvIGV4aXQgc3RhdHVzOiAyNTUKPj4gIFBhcnNlIGVy
cm9yczogQmFkIHBsYW4uICBZb3UgcGxhbm5lZCAxMSB0ZXN0cyBidXQgcmFuIDEwLgo+PiBGaWxl
cz0xLCBUZXN0cz0xMCwgIDAgd2FsbGNsb2NrIHNlY3MgKCAwLjAyIHVzciAgMC4wMCBzeXMgKyAg
MC41NCBjdXNyCj4+ICAwLjAzCj4+IGNzeXMgPSAgMC41OSBDUFUpCj4+IFJlc3VsdDogRkFJTAo+
Pgo+PiBJIGtlZXAgb24gdHJhY2tpbmcgZG93biB0aGlzIGlzc3VlLi4uCj4+IC0tCj4+IFZpZXcg
dGhpcyBtZXNzYWdlIGluIGNvbnRleHQ6Cj4+IGh0dHA6Ly9tb2pvbW9qby4yMzU4NDI3Lm4yLm5h
YmJsZS5jb20vUG9zdGdyZXNxbC1wcm9ibGVtLXdpdGgtR1JPVVAtQlktY2xhdXNlcy10cDU5MDg4
MDRwNTkxMjQwMS5odG1sCj4+IFNlbnQgZnJvbSB0aGUgbW9qb21vam8gbWFpbGluZyBsaXN0IGFy
Y2hpdmUgYXQgTmFiYmxlLmNvbS4KPj4KPj4gX19fX19fX19fX19fX19fX19fX19fX19fX19fX19f
X19fX19fX19fX19fX19fX18KPj4gTW9qb21vam8gbWFpbGluZyBsaXN0Cj4+IE1vam9tb2pvQGxp
c3RzLnNjc3lzLmNvLnVrCj4+IGh0dHA6Ly9saXN0cy5zY3N5cy5jby51ay9jZ2ktYmluL21haWxt
YW4vbGlzdGluZm8vbW9qb21vam8KPj4KPgo+Cj4gX19fX19fX19fX19fX19fX19fX19fX19fX19f
X19fX19fX19fX19fX19fX19fX18KPiBNb2pvbW9qbyBtYWlsaW5nIGxpc3QKPiBNb2pvbW9qb0Bs
aXN0cy5zY3N5cy5jby51awo+IGh0dHA6Ly9saXN0cy5zY3N5cy5jby51ay9jZ2ktYmluL21haWxt
YW4vbGlzdGluZm8vbW9qb21vam8KPgo+CgoKLS0gCi0tLQpNYXJjdXMgUmFtYmVyZwpDaGllZiBZ
YWsgU2hhdmVyCk5vcmRhYWtlciBDb25zdWx0aW5nCis0Ny05MzQxNzUwOAotLS0tLS0tLS0tLS0t
LSBuZXh0IHBhcnQgLS0tLS0tLS0tLS0tLS0KQW4gSFRNTCBhdHRhY2htZW50IHdhcyBzY3J1YmJl
ZC4uLgpVUkw6IGh0dHA6Ly9saXN0cy5zY3N5cy5jby51ay9waXBlcm1haWwvbW9qb21vam8vYXR0
YWNobWVudHMvMjAxMTAxMTIvOGZiMWQzMzMvYXR0YWNobWVudC5odG0K