Received: from localhost (unknown [200.46.208.211]) by mail.postgresql.org (Postfix) with ESMTP id B9CAB633EFF for ; Tue, 11 Aug 2009 14:05:25 -0300 (ADT) Received: from mail.postgresql.org ([200.46.204.86]) by localhost (mx1.hub.org [200.46.208.211]) (amavisd-maia, port 10024) with ESMTP id 54329-01 for ; Tue, 11 Aug 2009 17:05:13 +0000 (UTC) X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 Received: from mx3.actuate.com (unknown [212.140.245.163]) by mail.postgresql.org (Postfix) with ESMTP id C5124633189 for ; Tue, 11 Aug 2009 14:05:09 -0300 (ADT) Received: from exchange9.actuate.com ([192.168.213.9]) by mx3.actuate.com with Microsoft SMTPSVC(5.0.2195.6713); Tue, 11 Aug 2009 18:05:23 +0100 Received: from exchange8.actuate.com ([192.168.11.22]) by exchange9.actuate.com with Microsoft SMTPSVC(6.0.3790.3959); Tue, 11 Aug 2009 18:05:08 +0100 X-MimeOLE: Produced By Microsoft Exchange V6.5 Content-class: urn:content-classes:message MIME-Version: 1.0 Content-Type: text/plain; charset="utf-8" Content-Transfer-Encoding: base64 Subject: Re: Updating a specific number of rows in pl/pgsql Date: Tue, 11 Aug 2009 10:05:28 -0700 Message-ID: <71F491F5DA99604A80DE49424BF3D02B0C7292EF@exchange8.actuate.com> In-Reply-To: <162867790908110355g3b62cc56u1c74092dd01bbd8e@mail.gmail.com> X-MS-Has-Attach: X-MS-TNEF-Correlator: Thread-Topic: [SQL] Updating a specific number of rows in pl/pgsql Thread-Index: AcoackW71t86cEE5QESjoqXQcTW6SgAMlqRQ References: <71F491F5DA99604A80DE49424BF3D02B0C7290CA@exchange8.actuate.com> <20090811062503.86993bf6.darcy@druid.net> <162867790908110355g3b62cc56u1c74092dd01bbd8e@mail.gmail.com> From: "Peter Headland" To: "Pavel Stehule" , "D'Arcy J.M. Cain" Cc: X-OriginalArrivalTime: 11 Aug 2009 17:05:08.0990 (UTC) FILETIME=[E192C9E0:01CA1AA5] X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=-1.755 tagged_above=-10 required=5 tests=AWL=0.745, BAYES_00=-2.599, RDNS_NONE=0.1 X-Spam-Level: X-Archive-Number: 200908/46 X-Sequence-Number: 32955 PiB0aGVyZSBhcmUgb25lIGZhc3QgdHJpY2sNCj4gaHR0cDovL3d3dy5wb3N0Z3Jlcy5jei9pbmRl eC5waHAvUG9zdGdyZVNRTF9TUUxfVHJpY2tzI0Zhc3RfZmlyc3Rfbl9yb3dzX3JlbW92aW5nDQoN ClRoYW5rcyAtIHRoYXQncyBhIHZlcnkgdXNlZnVsIHBhZ2UhDQoNClVuZm9ydHVuYXRlbHksIHRo ZXJlIGlzIG5vIHNpbmdsZSBjb2x1bW4gdGhhdCBwcm92aWRlcyBhIHVuaXF1ZSBpZCwgYW5kIEkg YW0gcmVsdWN0YW50IHRvIGFkZCBvbmUgKGZvciBleGFtcGxlLCB1c2luZyBhIHNlcXVlbmNlIGFu ZCBhIG5ldyBpbmRleCkgZm9yIHBlcmZvcm1hbmNlIHJlYXNvbnMuDQoNCkdpdmVuIHRoYXQgYWRk aXRpb25hbCBjb25zdHJhaW50LCBpcyBteSBvcmlnaW5hbCBwbGFuIHVzaW5nIGEgbG9vcCB0byBp dGVyYXRlIG92ZXIgYSBjdXJzb3IgcmVhc29uYWJsZT8gSSBkb24ndCBhbnRpY2lwYXRlIHBfbnVt YmVyX29mX2l0ZW1zIGJlaW5nIG1vcmUgdGhhbiAyMC4NCg0KLS0gDQpQZXRlciBIZWFkbGFuZA0K QXJjaGl0ZWN0DQpBY3R1YXRlIENvcnBvcmF0aW9uDQoNCg0KLS0tLS1PcmlnaW5hbCBNZXNzYWdl LS0tLS0NCkZyb206IFBhdmVsIFN0ZWh1bGUgW21haWx0bzpwYXZlbC5zdGVodWxlQGdtYWlsLmNv bV0gDQpTZW50OiBUdWVzZGF5LCBBdWd1c3QgMTEsIDIwMDkgMDM6NTUNClRvOiBEJ0FyY3kgSi5N LiBDYWluDQpDYzogUGV0ZXIgSGVhZGxhbmQ7IHBnc3FsLXNxbEBwb3N0Z3Jlc3FsLm9yZw0KU3Vi amVjdDogUmU6IFtTUUxdIFVwZGF0aW5nIGEgc3BlY2lmaWMgbnVtYmVyIG9mIHJvd3MgaW4gcGwv cGdzcWwNCg0KMjAwOS84LzExIEQnQXJjeSBKLk0uIENhaW4gPGRhcmN5QGRydWlkLm5ldD46DQo+ IE9uIE1vbiwgMTAgQXVnIDIwMDkgMTc6NTI6MzYgLTA3MDANCj4gIlBldGVyIEhlYWRsYW5kIiA8 cGhlYWRsYW5kQGFjdHVhdGUuY29tPiB3cm90ZToNCj4+IEkgY2FuIGdldCB0aGUgcm93cyBJIHdh bnQgdG8gdXBkYXRlIGxpa2UgdGhpczoNCj4+DQo+PiDCoCBTRUxFQ1QgKg0KPj4gwqAgwqBGUk9N IHF1ZXVlDQo+PiDCoCDCoFdIRVJFIGlkID0gcF9xdWV1ZV9pZA0KPj4gwqAgwqBPUkRFUiBCWSBy YW5rDQo+PiDCoCDCoExJTUlUIHBfbnVtYmVyX29mX2l0ZW1zOw0KPj4NCj4+IE9mIGNvdXJzZSwg dGhlcmUgbWF5IG5vdCBiZSBwX251bWJlcl9vZl9pdGVtcyBhdmFpbGFibGUgaW4gdGhlIHF1ZXVl Lg0KPj4NCj4+IEkgd2FudCB0byB1cGRhdGUgYWxsIHRoZSByb3dzIGluIHRoZSBjdXJzb3IgaW4g dGhlIHNhbWUgd2F5Og0KPj4NCj4+IMKgIFVQREFURSBxdWV1ZSBTRVQgYXNzaWduZWQgPSBUUlVF Ow0KPg0KPiBBc3N1bWluZyB0aGF0IHRoZXJlIGlzIGEgdW5pcXVlIGlkZW50aWZpZXIgb24gcXVl dWUsIGxldCdzIGNhbGwgaXQNCj4gcXVldWVfaWQsIHlvdSBzaG91bGQgYmUgYWJsZSB0byBkbyBz b21ldGhpbmcgbGlrZSB0aGlzOg0KPg0KPiDCoFVQREFURSBxdWV1ZSBTRVQgYXNzaWduZWQgPSBU UlVFDQo+IMKgV0hFUkUgcXVldWVfaWQgSU4gKFNFTEVDVCBxdWV1ZV9pZA0KPiDCoCDCoEZST00g cXVldWUNCj4gwqAgwqBXSEVSRSBpZCA9IHBfcXVldWVfaWQNCj4gwqAgwqBPUkRFUiBCWSByYW5r DQo+IMKgIMKgTElNSVQgcF9udW1iZXJfb2ZfaXRlbXMpOw0KPg0KDQp0aGVyZSBhcmUgb25lIGZh c3QgdHJpY2sNCmh0dHA6Ly93d3cucG9zdGdyZXMuY3ovaW5kZXgucGhwL1Bvc3RncmVTUUxfU1FM X1RyaWNrcyNGYXN0X2ZpcnN0X25fcm93c19yZW1vdmluZw0KDQpwLnMuIHJlcGxhY2UgREVMRVRF IGJ5IFVQREFURQ0KcmVnYXJkcw0KUGF2ZWwgU3RlaHVsZQ0KDQo+IC0tDQo+IEQnQXJjeSBKLk0u IENhaW4gPGRhcmN5QGRydWlkLm5ldD4gwqAgwqAgwqAgwqAgfCDCoERlbW9jcmFjeSBpcyB0aHJl ZSB3b2x2ZXMNCj4gaHR0cDovL3d3dy5kcnVpZC5uZXQvZGFyY3kvIMKgIMKgIMKgIMKgIMKgIMKg IMKgIMKgfCDCoGFuZCBhIHNoZWVwIHZvdGluZyBvbg0KPiArMSA0MTYgNDI1IDEyMTIgwqAgwqAg KERvRCMwMDgyKSDCoCDCoChlTlRQKSDCoCB8IMKgd2hhdCdzIGZvciBkaW5uZXIuDQo+DQo+IC0t DQo+IFNlbnQgdmlhIHBnc3FsLXNxbCBtYWlsaW5nIGxpc3QgKHBnc3FsLXNxbEBwb3N0Z3Jlc3Fs Lm9yZykNCj4gVG8gbWFrZSBjaGFuZ2VzIHRvIHlvdXIgc3Vic2NyaXB0aW9uOg0KPiBodHRwOi8v d3d3LnBvc3RncmVzcWwub3JnL21haWxwcmVmL3Bnc3FsLXNxbA0KPg0K