Received: from magus.postgresql.org (magus.postgresql.org [87.238.57.229]) by mail.postgresql.org (Postfix) with ESMTP id 9B0C0EDF36D for ; Tue, 22 May 2012 04:29:00 -0300 (ADT) Received: from atlas.wxnz.net ([58.28.6.122]) by magus.postgresql.org with esmtp (Exim 4.72) (envelope-from ) id 1SWjWa-00033T-Rz for pgsql-sql@postgresql.org; Tue, 22 May 2012 07:28:59 +0000 Received: from central.omiha.com (ip-118-90-123-208.xdsl.xnet.co.nz [118.90.123.208]) by atlas.wxnz.net (Postfix) with ESMTP id 893B62D9101 for ; Tue, 22 May 2012 19:28:40 +1200 (NZST) Received: from [10.10.10.12] (unknown [10.10.10.12]) by central.omiha.com (Postfix) with ESMTP id 4BFF21ACCC for ; Tue, 22 May 2012 19:28:40 +1200 (NZST) Message-ID: <4FBB4027.1030609@greenpeace.org> Date: Tue, 22 May 2012 19:28:39 +1200 From: Jan Bakuwel Organization: Greenpeace (http://www.greenpeace.org) User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:12.0) Gecko/20120430 Thunderbird/12.0.1 MIME-Version: 1.0 To: pgsql-sql@postgresql.org Subject: Re: master/detail References: <4FB7EEC6.1030004@gmx.net> <4FB8B489.3050701@gmx.net> <4FB97B70.6080604@greenpeace.org> <1746662999.146825.1337574892585.JavaMail.open-xchange@ox.ims-firmen.de> In-Reply-To: <1746662999.146825.1337574892585.JavaMail.open-xchange@ox.ims-firmen.de> X-Enigmail-Version: 1.5pre Content-Type: multipart/signed; protocol="application/pkcs7-signature"; micalg=sha1; boundary="------------ms070701070800000304050704" X-Pg-Spam-Score: -1.9 (-) X-Archive-Number: 201205/60 X-Sequence-Number: 36608 This is a cryptographically signed message in MIME format. --------------ms070701070800000304050704 Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: quoted-printable Hi Andreas and Mario, Many thanks for your suggestion to use PostgreSQL's window function, exactly what I needed. kind regards, Jan --------------ms070701070800000304050704 Content-Type: application/pkcs7-signature; name="smime.p7s" Content-Transfer-Encoding: base64 Content-Disposition: attachment; filename="smime.p7s" Content-Description: S/MIME Cryptographic Signature MIAGCSqGSIb3DQEHAqCAMIACAQExCzAJBgUrDgMCGgUAMIAGCSqGSIb3DQEHAQAAoIIIDzCC CAswggXzoAMCAQICAyACKjANBgkqhkiG9w0BAQUFADCB+DEhMB8GA1UEChMYR3JlZW5wZWFj ZSBJbnRlcm5hdGlvbmFsMR4wHAYDVQQLExVDZXJ0aWZpY2F0ZSBBdXRob3JpdHkxMzAxBgkq hkiG9w0BCQEWJGNlcnRpZmljYXRlLmF1dGhvcml0eUBncmVlbnBlYWNlLm9yZzESMBAGA1UE BxMJQW1zdGVyZGFtMRYwFAYDVQQIEw1Ob3J0aCBIb2xsYW5kMQswCQYDVQQGEwJOTDFFMEMG A1UEAxM8R3JlZW5wZWFjZSBHbG9iYWwgQXV0aGVudGljYXRpb24gYW5kIEVuY3J5cHRpb24g Um9vdCBDQSAyMDEwMB4XDTExMDcxOTA5MjExNloXDTE2MDcxNzA5MjExNlowgb0xCzAJBgNV BAYTAk5MMRYwFAYDVQQIEw1Ob3J0aCBIb2xsYW5kMSEwHwYDVQQKExhHcmVlbnBlYWNlIElu dGVybmF0aW9uYWwxHjAcBgNVBAsTFUNlcnRpZmljYXRlIEF1dGhvcml0eTESMBAGA1UEBxMJ QW1zdGVyZGFtMRQwEgYDVQQDEwtqYW4uYmFrdXdlbDEpMCcGCSqGSIb3DQEJARYaamFuLmJh a3V3ZWxAZ3JlZW5wZWFjZS5vcmcwggIiMA0GCSqGSIb3DQEBAQUAA4ICDwAwggIKAoICAQCy 0wcYLAIQbP9MSESY1RaR/f8Ram8TIOPhajUK8dvMFqSb/7/21hPdsON0o21iPcfQP7pLPRTo FVpW2CnCfJuCzMZVx7n/o+T47S8sN2YzgqkUPd63HmPO4AIE8zdWOmG6aCuy5wttWitGPr3D krJzRA/WRbhKc+ebKJAfFMr8N9kKPK6tIMRcn52iZbMQUbGeAHzKXhrT9QH7p+r5V+89L8fJ YmI2zne7rIj8db3rxyZbsA11M5bXgDpJFeIwtibnBC/Jt00LViq8HHBM/eZUEwdPse90n17d 7tLeBuwZ7Dckkm+lugzhR2hnibVHtAdAquIotkgUqh3UQH4g2ZA0pPHwxf2xLfmFqVJj3Ode VmKkYsj/P16V1lQpXqX//7eRm1N9j8kKllig8N3jkBdZFwXjRtbe6DUnZQFrVBuIKfA63RHN sb6qas47RFOvVtblUY/DW2f6zCm6EsHtcMpNj8vxSeF5MUpO2y/YRXEDermXOyu/40yv8tXT YwIdTfba/EvO4EBnXm6IXGnUSp8NEAVhc0/kB9vJ+pq9XO/UHFvo9fOeu3T7KgMNN31QhxlG D2FGh5f8LlTNktRsdyMYCF2m85wUFV2GQOW3etGnEY4T0aLacikbWF/zwPYns9nnpvtTeKyP fGloh30zyo00OVqhNnREH7A48rSp4qYJRwIDAQABo4IB1TCCAdEwCQYDVR0TBAIwADAdBgNV HQ4EFgQU7Sg0TwH6c2T23HGF9Dhnjr/uEecwEQYJYIZIAYb4QgEBBAQDAgSwMCUGA1UdEQQe MByBGmphbi5iYWt1d2VsQGdyZWVucGVhY2Uub3JnMEoGA1UdJQRDMEEGCCsGAQUFBwMBBggr BgEFBQcDAgYIKwYBBQUHAwQGCisGAQQBgjcKAwMGCisGAQQBgjcKAwQGCWCGSAGG+EIEATCB uAYJYIZIAYb4QgENBIGqFoGnR3JlZW5wZWFjZSBpcyBhbiBpbmRlcGVuZGVudCBnbG9iYWwg Y2FtcGFpZ25pbmcgb3JnYW5pc2F0aW9uIHRoYXQgYWN0cyB0byBjaGFuZ2UgYXR0aXR1ZGVz IGFuZCBiZWhhdmlvdXIsIHRvIHByb3RlY3QgYW5kIGNvbnNlcnZlIHRoZSBlbnZpcm9ubWVu dCBhbmQgdG8gcHJvbW90ZSBwZWFjZS4wZAYDVR0fBF0wWzBZoFegVYZTaHR0cDovL2NybC5n cmVlbnBlYWNlLm9yZy9HcmVlbnBlYWNlR2xvYmFsQXV0aGVudGljYXRpb25BbmRFbmNyeXB0 aW9uUm9vdENBMjAxMC5jcmwwDQYJKoZIhvcNAQEFBQADggIBABeaDIOCNVnvH3b+KqlidkTj UKc51rm7JvxOhm84tgEJmuVk4NlAwxfXWKTGjVwzlvOG3OhpoxSc7rOnYTsxU27NDPbkRcIN GcOIsgrmwlhmUzMpgQ+bN9CyHbaEdNKm5Aa/OTXvu0kSsgEz4Q/1Z+yk5G3+dpP32DY1waq9 zy3XPOBUTjX/A2y/LyaxFxnipBpt+mbA1Zd39s11A/aGbFpC5HrMJd6WH5669B/U7gwMdIxE 15P2O9hjfMT/BxfmWsa7rDvC+RuUtD1rQxXgAYwwnJaiHHl23Cwl5UiDABbK+Ox6kg6PPpzs /vfPi7z0Cv7wwNsI7NMqVb2LTLbd3nmiqy7HSJCb4WyOh3jK9Aih7wH1BhFbIbygiP9B7UWX ng8PVqzuhwJV8Ef2emJY4bAvcstayqY5X0QQHgFDXO3PYXbWbUtzplIQXgV9JQNdS5zPNw95 O2dMTWCVaHQ+vKSziF0sudjrUbI+w5dH6dai6y7h8+7kqZ3EOs3NFU3bSn34o+22Ly04xpSN DLyQY3opgG5KVXJf5/GSPtC+mGIZm5O6Mgi4TWZecov37Gpm0d5G3tgZz8/i5Imdaq6zzRqW LUR9K/UdXDis1kkLZZdrjkop/UEchhkIE87snUIr27FPPkpK2l+suNYKHrK+AGKA9cWVmXjX wlBSrr/bnhxZMYIGGzCCBhcCAQEwggEAMIH4MSEwHwYDVQQKExhHcmVlbnBlYWNlIEludGVy bmF0aW9uYWwxHjAcBgNVBAsTFUNlcnRpZmljYXRlIEF1dGhvcml0eTEzMDEGCSqGSIb3DQEJ ARYkY2VydGlmaWNhdGUuYXV0aG9yaXR5QGdyZWVucGVhY2Uub3JnMRIwEAYDVQQHEwlBbXN0 ZXJkYW0xFjAUBgNVBAgTDU5vcnRoIEhvbGxhbmQxCzAJBgNVBAYTAk5MMUUwQwYDVQQDEzxH cmVlbnBlYWNlIEdsb2JhbCBBdXRoZW50aWNhdGlvbiBhbmQgRW5jcnlwdGlvbiBSb290IENB IDIwMTACAyACKjAJBgUrDgMCGgUAoIIC7jAYBgkqhkiG9w0BCQMxCwYJKoZIhvcNAQcBMBwG CSqGSIb3DQEJBTEPFw0xMjA1MjIwNzI4MzlaMCMGCSqGSIb3DQEJBDEWBBR9Px0R0+EuUJqQ ycPt9Zma3GQrrzBfBgkqhkiG9w0BCQ8xUjBQMAsGCWCGSAFlAwQBAjAKBggqhkiG9w0DBzAO BggqhkiG9w0DAgICAIAwDQYIKoZIhvcNAwICAUAwBwYFKw4DAgcwDQYIKoZIhvcNAwICASgw ggETBgkrBgEEAYI3EAQxggEEMIIBADCB+DEhMB8GA1UEChMYR3JlZW5wZWFjZSBJbnRlcm5h dGlvbmFsMR4wHAYDVQQLExVDZXJ0aWZpY2F0ZSBBdXRob3JpdHkxMzAxBgkqhkiG9w0BCQEW JGNlcnRpZmljYXRlLmF1dGhvcml0eUBncmVlbnBlYWNlLm9yZzESMBAGA1UEBxMJQW1zdGVy ZGFtMRYwFAYDVQQIEw1Ob3J0aCBIb2xsYW5kMQswCQYDVQQGEwJOTDFFMEMGA1UEAxM8R3Jl ZW5wZWFjZSBHbG9iYWwgQXV0aGVudGljYXRpb24gYW5kIEVuY3J5cHRpb24gUm9vdCBDQSAy MDEwAgMgAiowggEVBgsqhkiG9w0BCRACCzGCAQSgggEAMIH4MSEwHwYDVQQKExhHcmVlbnBl YWNlIEludGVybmF0aW9uYWwxHjAcBgNVBAsTFUNlcnRpZmljYXRlIEF1dGhvcml0eTEzMDEG CSqGSIb3DQEJARYkY2VydGlmaWNhdGUuYXV0aG9yaXR5QGdyZWVucGVhY2Uub3JnMRIwEAYD VQQHEwlBbXN0ZXJkYW0xFjAUBgNVBAgTDU5vcnRoIEhvbGxhbmQxCzAJBgNVBAYTAk5MMUUw QwYDVQQDEzxHcmVlbnBlYWNlIEdsb2JhbCBBdXRoZW50aWNhdGlvbiBhbmQgRW5jcnlwdGlv biBSb290IENBIDIwMTACAyACKjANBgkqhkiG9w0BAQEFAASCAgBIDLgey4sdhWkNMOVOEBY4 4zeFSxUaxzXH/o10uoQgEqrt3ACFyNleCO/SvGgvlxY4xkCgI7D7XUTyFtjA2Mu+1WXcE+PF ni/WbqHKJ/VbShaJkr8yNqMf6Eqkk+FcKhvJY2uK1kGBYaG3ZYoM8Ja8loZ/LZPOH6ut6zyY psuB44MHpP4Di89LeBVfcsSlUpV5MbUbhon5tJYWylptug8hqNId165QeHG7eSaNRLUHpPzv 9oWsxYAyqYq+ER6ANXCxMYnoIzmIHzY5i7SscplrW4PtzP8fsVmjMr/TUtg3yeW3/m9TZb5/ G4AbwMp34NBbq9sMN31mt9QrFvL9xx8ijkv1BEM+EzRL1DVkmoHbydulTpBszDlrjnanXKDR P2t4DIMuitHj4Cfc42u3v5N2BfBakeKsFUE5iVY9Q+Iiv46HFl7sF+LqzwY6OAsnVwRl/fwx DAsPwDjLCTqtiKi1McVsWJFV4Ob2VHeKJG09U0TUSFLX71lZ5QuzuEdutS5Y3RJxCsXnuedP HcHV9oIF8qJYqJ8RPRTjoAonydJ0gkPAPNTcwBZbHFmPOWiQBkpEmYNPWZr7B2SbHSTLC9OE m946n1+KaLF7G028jcSgR7HvhjpOrKJCfO7s1z+rnGnkj1FEYwXhCu8L332eF5pjB0D5YaK/ iHfVxTWjAT7gBgAAAAAAAA== --------------ms070701070800000304050704--