Received: from maia.hub.org (unknown [200.46.204.183]) by mail.postgresql.org (Postfix) with ESMTP id 2CC40633D46 for ; Tue, 11 Aug 2009 14:26:47 -0300 (ADT) Received: from mail.postgresql.org ([200.46.204.86]) by maia.hub.org (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 05444-02 for ; Tue, 11 Aug 2009 17:26:42 +0000 (UTC) X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 Received: from wyattearp.actuate.com (mx1.actuate.com [69.1.81.237]) by mail.postgresql.org (Postfix) with SMTP id 0656163385A for ; Tue, 11 Aug 2009 14:26:38 -0300 (ADT) Received: from exchange8.actuate.com (Not Verified[192.168.11.22]) by wyattearp.actuate.com with MailMarshal (v6, 1, 4, 441) id ; Tue, 11 Aug 2009 10:24:43 -0700 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:24:54 -0700 Message-ID: <71F491F5DA99604A80DE49424BF3D02B0C729313@exchange8.actuate.com> X-MS-Has-Attach: X-MS-TNEF-Correlator: Thread-Topic: [SQL] Updating a specific number of rows in pl/pgsql Thread-Index: AcoackW71t86cEE5QESjoqXQcTW6SgAMlqRQAADu2dA= References: <71F491F5DA99604A80DE49424BF3D02B0C7290CA@exchange8.actuate.com> <20090811062503.86993bf6.darcy@druid.net> <162867790908110355g3b62cc56u1c74092dd01bbd8e@mail.gmail.com> From: "Peter Headland" To: "Peter Headland" , "Pavel Stehule" , "D'Arcy J.M. Cain" Cc: X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=-2.599 tagged_above=-10 required=5 tests=BAYES_00=-2.599 X-Spam-Level: X-Archive-Number: 200908/48 X-Sequence-Number: 32957 PiBVbmZvcnR1bmF0ZWx5LCB0aGVyZSBpcyBubyBzaW5nbGUgY29sdW1uIHRoYXQgcHJvdmlkZXMg YSB1bmlxdWUgaWQuDQoNCkNvcnJlY3Rpb24gLSBJIGRpZCBub3QgdW5kZXJzdGFuZCB3aGF0IGN0 aWQgd2FzLCBidXQgbm93IEkgZG8sIHNvIEkgd2lsbCB0cnkgeW91ciB0aXAuDQoNCi0tIA0KUGV0 ZXIgSGVhZGxhbmQNCkFyY2hpdGVjdA0KQWN0dWF0ZSBDb3Jwb3JhdGlvbg0KDQoNCi0tLS0tT3Jp Z2luYWwgTWVzc2FnZS0tLS0tDQpGcm9tOiBQZXRlciBIZWFkbGFuZCANClNlbnQ6IFR1ZXNkYXks IEF1Z3VzdCAxMSwgMjAwOSAxMDowNQ0KVG86ICdQYXZlbCBTdGVodWxlJzsgRCdBcmN5IEouTS4g Q2Fpbg0KQ2M6IHBnc3FsLXNxbEBwb3N0Z3Jlc3FsLm9yZw0KU3ViamVjdDogUkU6IFtTUUxdIFVw ZGF0aW5nIGEgc3BlY2lmaWMgbnVtYmVyIG9mIHJvd3MgaW4gcGwvcGdzcWwNCg0KPiB0aGVyZSBh cmUgb25lIGZhc3QgdHJpY2sNCj4gaHR0cDovL3d3dy5wb3N0Z3Jlcy5jei9pbmRleC5waHAvUG9z dGdyZVNRTF9TUUxfVHJpY2tzI0Zhc3RfZmlyc3Rfbl9yb3dzX3JlbW92aW5nDQoNClRoYW5rcyAt IHRoYXQncyBhIHZlcnkgdXNlZnVsIHBhZ2UhDQoNClVuZm9ydHVuYXRlbHksIHRoZXJlIGlzIG5v IHNpbmdsZSBjb2x1bW4gdGhhdCBwcm92aWRlcyBhIHVuaXF1ZSBpZCwgYW5kIEkgYW0gcmVsdWN0 YW50IHRvIGFkZCBvbmUgKGZvciBleGFtcGxlLCB1c2luZyBhIHNlcXVlbmNlIGFuZCBhIG5ldyBp bmRleCkgZm9yIHBlcmZvcm1hbmNlIHJlYXNvbnMuDQoNCkdpdmVuIHRoYXQgYWRkaXRpb25hbCBj b25zdHJhaW50LCBpcyBteSBvcmlnaW5hbCBwbGFuIHVzaW5nIGEgbG9vcCB0byBpdGVyYXRlIG92 ZXIgYSBjdXJzb3IgcmVhc29uYWJsZT8gSSBkb24ndCBhbnRpY2lwYXRlIHBfbnVtYmVyX29mX2l0 ZW1zIGJlaW5nIG1vcmUgdGhhbiAyMC4NCg0KLS0gDQpQZXRlciBIZWFkbGFuZA0KQXJjaGl0ZWN0 DQpBY3R1YXRlIENvcnBvcmF0aW9uDQoNCg0KLS0tLS1PcmlnaW5hbCBNZXNzYWdlLS0tLS0NCkZy b206IFBhdmVsIFN0ZWh1bGUgW21haWx0bzpwYXZlbC5zdGVodWxlQGdtYWlsLmNvbV0gDQpTZW50 OiBUdWVzZGF5LCBBdWd1c3QgMTEsIDIwMDkgMDM6NTUNClRvOiBEJ0FyY3kgSi5NLiBDYWluDQpD YzogUGV0ZXIgSGVhZGxhbmQ7IHBnc3FsLXNxbEBwb3N0Z3Jlc3FsLm9yZw0KU3ViamVjdDogUmU6 IFtTUUxdIFVwZGF0aW5nIGEgc3BlY2lmaWMgbnVtYmVyIG9mIHJvd3MgaW4gcGwvcGdzcWwNCg0K MjAwOS84LzExIEQnQXJjeSBKLk0uIENhaW4gPGRhcmN5QGRydWlkLm5ldD46DQo+IE9uIE1vbiwg MTAgQXVnIDIwMDkgMTc6NTI6MzYgLTA3MDANCj4gIlBldGVyIEhlYWRsYW5kIiA8cGhlYWRsYW5k QGFjdHVhdGUuY29tPiB3cm90ZToNCj4+IEkgY2FuIGdldCB0aGUgcm93cyBJIHdhbnQgdG8gdXBk YXRlIGxpa2UgdGhpczoNCj4+DQo+PiDCoCBTRUxFQ1QgKg0KPj4gwqAgwqBGUk9NIHF1ZXVlDQo+ PiDCoCDCoFdIRVJFIGlkID0gcF9xdWV1ZV9pZA0KPj4gwqAgwqBPUkRFUiBCWSByYW5rDQo+PiDC oCDCoExJTUlUIHBfbnVtYmVyX29mX2l0ZW1zOw0KPj4NCj4+IE9mIGNvdXJzZSwgdGhlcmUgbWF5 IG5vdCBiZSBwX251bWJlcl9vZl9pdGVtcyBhdmFpbGFibGUgaW4gdGhlIHF1ZXVlLg0KPj4NCj4+ IEkgd2FudCB0byB1cGRhdGUgYWxsIHRoZSByb3dzIGluIHRoZSBjdXJzb3IgaW4gdGhlIHNhbWUg d2F5Og0KPj4NCj4+IMKgIFVQREFURSBxdWV1ZSBTRVQgYXNzaWduZWQgPSBUUlVFOw0KPg0KPiBB c3N1bWluZyB0aGF0IHRoZXJlIGlzIGEgdW5pcXVlIGlkZW50aWZpZXIgb24gcXVldWUsIGxldCdz IGNhbGwgaXQNCj4gcXVldWVfaWQsIHlvdSBzaG91bGQgYmUgYWJsZSB0byBkbyBzb21ldGhpbmcg bGlrZSB0aGlzOg0KPg0KPiDCoFVQREFURSBxdWV1ZSBTRVQgYXNzaWduZWQgPSBUUlVFDQo+IMKg V0hFUkUgcXVldWVfaWQgSU4gKFNFTEVDVCBxdWV1ZV9pZA0KPiDCoCDCoEZST00gcXVldWUNCj4g wqAgwqBXSEVSRSBpZCA9IHBfcXVldWVfaWQNCj4gwqAgwqBPUkRFUiBCWSByYW5rDQo+IMKgIMKg TElNSVQgcF9udW1iZXJfb2ZfaXRlbXMpOw0KPg0KDQp0aGVyZSBhcmUgb25lIGZhc3QgdHJpY2sN Cmh0dHA6Ly93d3cucG9zdGdyZXMuY3ovaW5kZXgucGhwL1Bvc3RncmVTUUxfU1FMX1RyaWNrcyNG YXN0X2ZpcnN0X25fcm93c19yZW1vdmluZw0KDQpwLnMuIHJlcGxhY2UgREVMRVRFIGJ5IFVQREFU RQ0KcmVnYXJkcw0KUGF2ZWwgU3RlaHVsZQ0KDQo+IC0tDQo+IEQnQXJjeSBKLk0uIENhaW4gPGRh cmN5QGRydWlkLm5ldD4gwqAgwqAgwqAgwqAgfCDCoERlbW9jcmFjeSBpcyB0aHJlZSB3b2x2ZXMN Cj4gaHR0cDovL3d3dy5kcnVpZC5uZXQvZGFyY3kvIMKgIMKgIMKgIMKgIMKgIMKgIMKgIMKgfCDC oGFuZCBhIHNoZWVwIHZvdGluZyBvbg0KPiArMSA0MTYgNDI1IDEyMTIgwqAgwqAgKERvRCMwMDgy KSDCoCDCoChlTlRQKSDCoCB8IMKgd2hhdCdzIGZvciBkaW5uZXIuDQo+DQo+IC0tDQo+IFNlbnQg dmlhIHBnc3FsLXNxbCBtYWlsaW5nIGxpc3QgKHBnc3FsLXNxbEBwb3N0Z3Jlc3FsLm9yZykNCj4g VG8gbWFrZSBjaGFuZ2VzIHRvIHlvdXIgc3Vic2NyaXB0aW9uOg0KPiBodHRwOi8vd3d3LnBvc3Rn cmVzcWwub3JnL21haWxwcmVmL3Bnc3FsLXNxbA0KPg0K