Received: from localhost (unknown [200.46.204.191]) by postgresql.org (Postfix) with ESMTP id EF7009FBA94 for ; Mon, 29 Oct 2007 12:46:49 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.191]) (amavisd-maia, port 10024) with ESMTP id 38708-04 for ; Mon, 29 Oct 2007 12:46:40 -0300 (ADT) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.5 Received: from nz-out-0506.google.com (nz-out-0506.google.com [64.233.162.225]) by postgresql.org (Postfix) with ESMTP id DA3D49FBB69 for ; Mon, 29 Oct 2007 12:46:35 -0300 (ADT) Received: by nz-out-0506.google.com with SMTP id l8so1070929nzf for ; Mon, 29 Oct 2007 08:46:32 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=beta; h=domainkey-signature:received:received:message-id:date:from:to:subject:cc:in-reply-to:mime-version:content-type:content-transfer-encoding:content-disposition:references; bh=zwX2tat0Gx6dlUjj/d6bwZYst0aLlJ/SgxCObOw9oSE=; b=BtjZ29xlTjsCzc1n/lUh0BX/1rTz1zCZljPn6RXyjaUDHaje6+/2JsMA6wUbIh5aCkzY2JE86F2hZ+tmo2OeMF46zzj5caPemU14k/nNRnaxeNZUE2Bg24bcgir6t5AcMTI8flg5MDDlXlmSfyHgk7wDVDxJSbyL9VK1daqoQQU= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=beta; h=received:message-id:date:from:to:subject:cc:in-reply-to:mime-version:content-type:content-transfer-encoding:content-disposition:references; b=bC+zkgYMuv6gayjYXyU5ICzTzwMCwh+hHrnYiBKwJTwMIFgpPOivfbmMPV5N/2fYFqlgm9z/sqJntZIZPgmKUUJstNNxnxGdOlxEZk3agt48Paq32unnZtLHcLOcNqqR6CPkIYGzUjRBQAp5PewNkT6omwSYHnbLJX61EQD0Zms= Received: by 10.114.254.1 with SMTP id b1mr411245wai.1193672791228; Mon, 29 Oct 2007 08:46:31 -0700 (PDT) Received: by 10.114.193.15 with HTTP; Mon, 29 Oct 2007 08:46:31 -0700 (PDT) Message-ID: <162867790710290846r5ca06054w1a18fa17514546e9@mail.gmail.com> Date: Mon, 29 Oct 2007 16:46:31 +0100 From: "Pavel Stehule" To: "dev@kbsolutions.ch" Subject: Re: update from select Cc: pgsql-sql@postgresql.org In-Reply-To: <0f0501c81a40$538ce1b0$1601a8c0@kbsc1> MIME-Version: 1.0 Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: base64 Content-Disposition: inline References: <0d5e01c81a0c$b0f67250$1601a8c0@kbsc1> <20071029104529.GB16653@a-kretschmer.de> <0f0501c81a40$538ce1b0$1601a8c0@kbsc1> X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200710/147 X-Sequence-Number: 29519 MjAwNy8xMC8yOSwgZGV2QGtic29sdXRpb25zLmNoIDxkZXZAa2Jzb2x1dGlvbnMuY2g+Ogo+Cj4g WWVzLCBib3RoIGhhdmUgdmFyY2hhcig1MCkuCj4KPiBRdWVyeToKPgo+IFVQREFURSBvd25lciBT RVQgcGljdHVyZW1lZGl1bSA9IGR2ZHMucGljdHVyZW1lZGl1bSwgdGl0bGUgPSBkdmRzLnRpdGxl LAo+IHRpdGxlT3JkZXIgPSBkdmRzLnRpdGxlLCByZWxlYXNlZGF0ZSA9IENBU1QoZHZkcy5yZWxl YXNlZGF0ZSBBUyBkYXRlKSBGUk9NCj4gKAo+ICAgICAgICAgU0VMRUNUIERJU1RJTkNUCj4gICAg ICAgICBkZXRhaWxfZHZkLmFzaW4sCj4gICAgICAgICBkZXRhaWxfZHZkLnBpY3R1cmVtZWRpdW0s Cj4gICAgICAgICBkZXRhaWxfZHZkLnRpdGxlLAo+ICAgICAgICAgZGV0YWlsX2R2ZC5yZWxlYXNl ZGF0ZQo+ICAgICAgICAgRlJPTSBkZXRhaWxfZHZkCj4gICAgICAgICBXSEVSRSByZWxlYXNlZGF0 ZSBJUyBOT1QgTlVMTCBBTkQgcmVsZWFzZWRhdGUgPD4gJycgQU5ECj4gKGxlbmd0aChyZWxlYXNl ZGF0ZSkgPSAxMCBPUiBsZW5ndGgocmVsZWFzZWRhdGUpID0gMjMpCj4gKQo+IEFTIGR2ZHMgV0hF UkUgb3duZXIuYXNpbiA9IGR2ZHMuYXNpbjsKPgo+ICoqKioqKioqKioqKioqKioqKioqKioqKioq KioqKioqKioqKioqKioqKioqKioqKioqKioqKioqKioqCj4gRVhQTEFJTiBBTkFMWVpFOgo+Cj4g SGFzaCBKb2luICAoY29zdD0xMDgyNy40NS4uMjU5NTAuMDUgcm93cz00OTA2IHdpZHRoPTExOTEp IChhY3R1YWwKPiB0aW1lPTU4Ni4yNTEuLjI4NTIuNjkxIHJvd3M9MTExMzA2IGxvb3BzPTEpCj4g IiAgSGFzaCBDb25kOiAoKCIib3duZXIiIi5hc2luKTo6dGV4dCA9IChkdmRzLmFzaW4pOjp0ZXh0 KSIKPiAiICAtPiAgU2VxIFNjYW4gb24gIiJvd25lciIiICAoY29zdD0wLjAwLi4xNDE0OC45OCBy b3dzPTIzMDE5OCB3aWR0aD0xMDEpCj4gKGFjdHVhbCB0aW1lPTAuMDUwLi45NjguMDI4IHJvd3M9 MjMwMTk4IGxvb3BzPTEpIgo+ICAgLT4gIEhhc2ggIChjb3N0PTEwODI1LjAyLi4xMDgyNS4wMiBy b3dzPTE5NCB3aWR0aD0xMjA4KSAoYWN0dWFsCj4gdGltZT01ODQuNDYzLi41ODQuNDYzIHJvd3M9 MTk0ODkgbG9vcHM9MSkKPiAgICAgICAgIC0+ICBTdWJxdWVyeSBTY2FuIGR2ZHMgIChjb3N0PTEw ODIwLjY2Li4xMDgyNS4wMiByb3dzPTE5NAo+IHdpZHRoPTEyMDgpIChhY3R1YWwgdGltZT00MzUu MDA1Li41NDUuMjEzIHJvd3M9MTk0ODkgbG9vcHM9MSkKPiAgICAgICAgICAgICAgIC0+ICBVbmlx dWUgIChjb3N0PTEwODIwLjY2Li4xMDgyMy4wOCByb3dzPTE5NCB3aWR0aD0xMTApCj4gKGFjdHVh bCB0aW1lPTQzNS4wMDIuLjUyMC43MjUgcm93cz0xOTQ4OSBsb29wcz0xKQo+ICAgICAgICAgICAg ICAgICAgICAgLT4gIFNvcnQgIChjb3N0PTEwODIwLjY2Li4xMDgyMS4xNCByb3dzPTE5NCB3aWR0 aD0xMTApCj4gKGFjdHVhbCB0aW1lPTQzNC45OTguLjQ5MS40ODcgcm93cz0xOTQ4OSBsb29wcz0x KQo+ICAgICAgICAgICAgICAgICAgICAgICAgICAgU29ydCBLZXk6IGFzaW4sIHBpY3R1cmVtZWRp dW0sIHRpdGxlLCByZWxlYXNlZGF0ZQo+ICAgICAgICAgICAgICAgICAgICAgICAgICAgLT4gIFNl cSBTY2FuIG9uIGRldGFpbF9kdmQgIChjb3N0PTAuMDAuLjEwODEzLjI5Cj4gcm93cz0xOTQgd2lk dGg9MTEwKSAoYWN0dWFsIHRpbWU9MC4wNDIuLjE2Ni40OTMgcm93cz0xOTQ4OSBsb29wcz0xKQo+ ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgRmlsdGVyOiAoKHJlbGVhc2VkYXRlIElT IE5PVCBOVUxMKSBBTkQKPiAoKHJlbGVhc2VkYXRlKTo6dGV4dCA8PiAnJzo6dGV4dCkgQU5EICgo bGVuZ3RoKChyZWxlYXNlZGF0ZSk6OnRleHQpID0gMTApIE9SCj4gKGxlbmd0aCgocmVsZWFzZWRh dGUpOjp0ZXh0KSA9IDIzKSkpCj4gVG90YWwgcnVudGltZTogNjMzNTQ4LjQwNCBtcwo+ICoqKioq KioqKioqKioqKioqKioqKioqKioqKioqKioqKioqKioqKioqKioqKioqKioqKioqKioqKioqCj4K PiBIZSBpcyBub3QgdXNpbmcgdGhlIGluZGV4IG9uIGFzaW4/IFdoZW4gSSByZWR1Y2UgdGhlIFNF TEVDVCB0byAxMDAsIGhlIGlzCj4gdXNpbmcgdGhlIGluZGV4ISBwZXJoYXBzIHRvIG1hbnkgcm93 cyBhcmUgYWZmZWN0ZWQ/Cj4gVGhlIERJU1RJTkNUIGluIHRoZSBTRUxFQ1QgaXMgbm90IHJlYWxs eSBuZWNlc3NhcnkuIEl0J3MganVzdCBmb3Igc2VjdXJpdHkKPiByZWFzb25zLiBBbmQgSSBkaWQg Y2hlY2sgaXQuIEl0J3MgdW5pcXVlISBCdXQgYXMgSSBzYWlkIGJlZm9yZS4gVGhlIFNFTEVDVAo+ IHRha2VzIGFyb3VuZCAxIHNlY29uZCEgSSBoYXZlIDEzIGluZGljZXMgb24gdGhlIFVQREFURSB0 YWJsZS4gU28gSSBkaWQKPiBkZWxldGUgdGhlIG9uZSBJIGRvbid0IG5lZWQgZm9yIHRoaXMgcXVl cnkuLi4gTm93IEkgaGF2ZSAzIGxlZnQhIEFuZCBpdAo+IHRha2VzIGFyb3VuZCAyIE1pbnV0ZXMh IEJ1dCB0aGF0J3MgYWxzbyBhIHByb2JsZW0sIGJlY2F1c2UgSSBuZWVkIHRoZQo+IEluZGV4ZXMg YWdhaW4hIElzIGl0IHBvc3NpYmxlIHRvIHNldCB0aGUgd2F5LCBQb3N0Z3JlcyBpcyBidWlsZGlu ZyB0aGUKPiBpbmRpY2VzPyBPciBpcyB0aGUgb25seSB3YXkgZGVsZXRpbmcgdGhlIGluZGVjZXMg YmVmb3JlIFVQREFURSBhbmQgdGhlbgo+IGNyZWF0aW5nIHRoZW0gYWdhaW4/Cj4KPgo+IEkgYWxz byB0cmllZCB0aGlzIHF1ZXJ5IChQb3N0Z3JlU1FMJ3MgZXh0ZW5zaW9uKToKPgo+IFVQREFURSBv d25lciBTRVQgcGljdHVyZW1lZGl1bSA9IGRldGFpbF9kdmQucGljdHVyZW1lZGl1bSwgdGl0bGUg PQo+IGRldGFpbF9kdmQudGl0bGUsIHRpdGxlT3JkZXIgPSBkZXRhaWxfZHZkLnRpdGxlLCByZWxl YXNlZGF0ZSA9Cj4gQ0FTVChkZXRhaWxfZHZkLnJlbGVhc2VkYXRlIEFTIGRhdGUpCj4gRlJPTSBk ZXRhaWxfZHZkCj4gV0hFUkUgb3duZXIuYXNpbiA9IGRldGFpbF9kdmQuYXNpbgo+IEFORCBkZXRh aWxfZHZkLnJlbGVhc2VkYXRlIElTIE5PVCBOVUxMCj4gQU5EIGRldGFpbF9kdmQucmVsZWFzZWRh dGUgPD4gJycKPiBBTkQgKGxlbmd0aChkZXRhaWxfZHZkLnJlbGVhc2VkYXRlKSA9IDEwIE9SIGxl bmd0aChkZXRhaWxfZHZkLnJlbGVhc2VkYXRlKSA9Cj4gMjMpOwo+Cj4gQnV0IGl0cyBhbHNvIHRv IHNsb3c6Cj4KPiAqKioqKioqKioqKioqKioqKioqKioqKioqKioqKioqKioqKioqKioqKioqKioq KioqKioqKioqKioqKgo+IEVYUExBSU4gQU5BTFlaRToKPgo+IE5lc3RlZCBMb29wICAoY29zdD0w LjAwLi4yODE3NS43NSByb3dzPTIwMDYgd2lkdGg9MTk1KSAoYWN0dWFsCj4gdGltZT0wLjEzOC4u MTI3Njk1LjEzMiByb3dzPTExMTMwNiBsb29wcz0xKQo+ICAgLT4gIFNlcSBTY2FuIG9uIGRldGFp bF9kdmQgIChjb3N0PTAuMDAuLjEwODEzLjI5IHJvd3M9MTk0IHdpZHRoPTExMCkKPiAoYWN0dWFs IHRpbWU9MC4wMzUuLjYxNS41MTEgcm93cz0xOTQ4OSBsb29wcz0xKQo+ICAgICAgICAgRmlsdGVy OiAoKHJlbGVhc2VkYXRlIElTIE5PVCBOVUxMKSBBTkQgKChyZWxlYXNlZGF0ZSk6OnRleHQgPD4K PiAnJzo6dGV4dCkgQU5EICgobGVuZ3RoKChyZWxlYXNlZGF0ZSk6OnRleHQpID0gMTApIE9SCj4g KGxlbmd0aCgocmVsZWFzZWRhdGUpOjp0ZXh0KSA9IDIzKSkpCj4gIiAgLT4gIEluZGV4IFNjYW4g dXNpbmcgIiJpaWR4LW93bmVyLWFzaW4iIiBvbiAiIm93bmVyIiIgIChjb3N0PTAuMDAuLjg5LjA0 Cj4gcm93cz0yNiB3aWR0aD05OSkgKGFjdHVhbCB0aW1lPTIuODQ4Li42LjQ4NSByb3dzPTYgbG9v cHM9MTk0ODkpIgo+ICIgICAgICAgIEluZGV4IENvbmQ6ICgoIiJvd25lciIiLmFzaW4pOjp0ZXh0 ID0gKGRldGFpbF9kdmQuYXNpbik6OnRleHQpIgo+IFRvdGFsIHJ1bnRpbWU6IDEwMzk5OTguMzI1 IG1zCj4gKioqKioqKioqKioqKioqKioqKioqKioqKioqKioqKioqKioqKioqKioqKioqKioqKioq KioqKioqKioKPgoKdHJ5IHRvIHVwIHN0YXRpc3Rpc3RpY3Mgb24gdGFibGUgZGV0YWlsX2R2ZC5y ZWxlYXNlX2RhdGUuIE1heWJlIHRoZXJlCmlzIG90aGVyIHByb2JsZW0uIFRoZSBjYXN0aW5nIGZy b20gKHByb2JhYmx5KSBkYXRlIHRvIHRleHQgaW4KcmVsZWFzZWRhdGUgY29sdW1uLiBJcyBpdCBj b3JyZWN0PwoKd2hhdCBpcyBvcmlnaW5hbCB0eXBlIGZvciByZWxlYXNlZGF0ZSBjb2x1bW4/CgpQ YXZlbAo+Cj4gVGhha3MgZm9yIGhlbHBpbmchISBCeWUgdGhlIHdheSwgd2UgYXJlIGNoYW5naW5n IG91ciBzeXN0ZW0gZnJvbSBNU1NRTDIwMDAKPiB0byBQb3N0Z3JlcyA6LSkhCj4KPiBSZWdhcmRz Cj4gUmV0bwo+Cj4KPiAtLS0tLVVyc3Byw7xuZ2xpY2hlIE5hY2hyaWNodC0tLS0tCj4gVm9uOiBw Z3NxbC1zcWwtb3duZXJAcG9zdGdyZXNxbC5vcmcgW21haWx0bzpwZ3NxbC1zcWwtb3duZXJAcG9z dGdyZXNxbC5vcmddCj4gSW0gQXVmdHJhZyB2b24gQS4gS3JldHNjaG1lcgo+IEdlc2VuZGV0OiBN b250YWcsIDI5LiBPa3RvYmVyIDIwMDcgMTE6NDUKPiBBbjogcGdzcWwtc3FsQHBvc3RncmVzcWwu b3JnCj4gQmV0cmVmZjogUmU6IFtTUUxdIHVwZGF0ZSBmcm9tIHNlbGVjdAo+Cj4gYW0gIE1vbiwg ZGVtIDI5LjEwLjIwMDcsIHVtIDEwOjE4OjM4ICswMTAwIG1haWx0ZSBkZXZAa2Jzb2x1dGlvbnMu Y2gKPiBmb2xnZW5kZXM6Cj4gPgo+ID4gV0hFUkUgdGFibGUxLmNvbHVtbjEgPSB0ZW1wX3RhYmxl LmNvbHVtbjE7Cj4KPiB0YWJsZTEuY29sdW1uMSBhbmQgdGVtcF90YWJsZS5jb2x1bW4xIGhhdmUg dGhlIHNhbWUgdHlwZT8KPgo+ID4KPiA+Cj4gPgo+ID4gVGhlIHNlbGVjdCBieSBpdD9zIG93biB0 YWtlcyBhcm91bmQgMSBzZWNvbmQuIFRoZSBVcGRhdGUgaXMgYXJvdW5kIDEyMD8wMDAKPiA+IHJv d3MuIEkgZ290IGFuIGluZGV4IG9uIGNvbHVtbjEuIFRoZSB3aG9sZSBxdWVyeSBuZWVkcyBhcm91 bmQgMTYgbWludXRlcy4KPgo+IFNob3cgdXMgdGhlIEVYUExBSU4gQU5BTFlTRSAtIHJlc3VsdC4K Pgo+Cj4gQW5kcmVhcwo+IC0tCj4gQW5kcmVhcyBLcmV0c2NobWVyCj4gS29udGFrdDogIEhleW5p dHo6IDAzNTI0Mi80NzE1MCwgICBEMTogMDE2MC83MTQxNjM5IChtZWhyOiAtPiBIZWFkZXIpCj4g R251UEctSUQ6ICAgMHgzRkZGNjA2QywgcHJpdmF0IDB4N0Y0NTg0REEgICBodHRwOi8vd3d3a2V5 cy5kZS5wZ3AubmV0Cj4KPiAtLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0oZW5kIG9mIGJyb2Fk Y2FzdCktLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0KPiBUSVAgNzogWW91IGNhbiBoZWxwIHN1 cHBvcnQgdGhlIFBvc3RncmVTUUwgcHJvamVjdCBieSBkb25hdGluZyBhdAo+Cj4gICAgICAgICAg ICAgICAgIGh0dHA6Ly93d3cucG9zdGdyZXNxbC5vcmcvYWJvdXQvZG9uYXRlCj4KPgo+IC0tLS0t LS0tLS0tLS0tLS0tLS0tLS0tLS0tLShlbmQgb2YgYnJvYWRjYXN0KS0tLS0tLS0tLS0tLS0tLS0t LS0tLS0tLS0tLQo+IFRJUCAzOiBIYXZlIHlvdSBjaGVja2VkIG91ciBleHRlbnNpdmUgRkFRPwo+ Cj4gICAgICAgICAgICAgICAgaHR0cDovL3d3dy5wb3N0Z3Jlc3FsLm9yZy9kb2NzL2ZhcQo+Cg==