Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.96) (envelope-from ) id 1vyZqM-000EAo-2X for pgsql-novice@arkaria.postgresql.org; Fri, 06 Mar 2026 18:24:10 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.96) (envelope-from ) id 1vyZqK-006TQa-32 for pgsql-novice@arkaria.postgresql.org; Fri, 06 Mar 2026 18:24:09 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.96) (envelope-from ) id 1vyZqK-006TQS-2E for pgsql-novice@lists.postgresql.org; Fri, 06 Mar 2026 18:24:09 +0000 Received: from mx2.alte-leipziger.de ([91.217.145.232]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.98.2) (envelope-from ) id 1vyZqI-00000001Dzp-1zyn for pgsql-novice@lists.postgresql.org; Fri, 06 Mar 2026 18:24:08 +0000 X-CSE-ConnectionGUID: Jz7Ma2RGTSy+EWpc6ZcbgQ== X-CSE-MsgGUID: RG96WYpHR6mfLeFZV7oN6g== From: "Subramanian,Ramachandran" To: Laurenz Albe , "pgsql-novice@lists.postgresql.org" Subject: AW: SQL - How to iterate with delay in a loop Thread-Topic: SQL - How to iterate with delay in a loop Thread-Index: AdytYTn1S3tW22UjQaaujhAZjcHBDQAAnYEAAAyjmWA= Date: Fri, 6 Mar 2026 18:24:01 +0000 Message-ID: <7638801a4dc64c26bb2196607d1b48cc@alte-leipziger.de> References: <6c2c6ae6d61a467a91d08414e38b50c5@alte-leipziger.de> <12a672903852221b22d90692c1d8933c054ee7b7.camel@cybertec.at> In-Reply-To: <12a672903852221b22d90692c1d8933c054ee7b7.camel@cybertec.at> Accept-Language: de-DE, en-US Content-Language: de-DE X-MS-Has-Attach: X-MS-TNEF-Correlator: x-tmase-matchedrid: 9D5R5CjVwBbMAADY0A2wmVY9XYa1m8xA1gfGMJv7tZKA/R4QfleZcyoT 756lX7Xv5xGTujMZsKQHZ2xr2Y5exRlYL/cEtOXTcRrIPf5NYRxqtDQ+5oGtJyvC8vN7zcoCHse bgBXUPy8EFS9NgPWyL2wL2sGBnvJO4YGaIMv8lchsBBK+dj8AxfAGVu/oDaLstP+boK6EYrHVsV Z8VII5gwRNPBPWCSrV1c04BDYxKLYmkrgX3CciJmLK5A5md0r9rg4L214qcZ8q5Dz9thMoWylPu 1QpFLZQ9kH0/X+rfE6hRRbai6y+bbcEJ6fTriQeWlhx7pIX+r+gYfuARVNy9siD/+Fa+l4oN4j0 ZnWAOGgroQBlUoA5NzyV3D5IMRMJm2C2cLnXbN+PaW6Ua24rHSDFuFEiHCqrftwZ3X11IV0= x-tm-as-user-approved-sender: No x-tm-as-user-blocked-sender: No x-tmase-result: 10--4.585300-8.000000 x-tm-snts-smtp: 8B0EAA34C41F96764E8D740D4BF01175BF95E25A43B3B40433CE215FB6813F442000:8 x-alsentwithgood: false Content-Type: text/plain; charset="utf-8" Content-Transfer-Encoding: base64 MIME-Version: 1.0 X-GBS-PROC: EHofQTKKgmLjDkEgqCvtNWfLjZpqBakWkPsSZelKj7X6pUX50yji89ZJC13sHA02 X-GBS-PROCJOB: =?utf-8?Q?S2OG5yeSU0J3TYpyxPh7sqH4o/alsJmy9InjeQUcwNdcIu9mJEesQxao0pzB?= =?utf-8?Q?eJrKp0vW14ISxgkHc2fKr1wijTaJ6YONW+lcVhbqQzvUprIMSWY9wdkTfspk?= =?utf-8?Q?ygwDEbUMqIODgjxcshDCQGwTZBFmAvWVS2JEAI5ykFwm4JhAI0Q=3D?= List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk VGhhbmsgeW91IHNvIG11Y2guIFRoYXQgd29ya2VkIHBlcmZlY3RseS4gIPCfmIogDQoNCkxH DQoNClJhbQ0KDQoNCmlkX2NvbHVtbiB8ICAgICAgIHNhdmVkX3RzX25vX3R6ICAgICAgIHwg ICAgICAgc2F2ZWRfdHNfd2l0aF90eiAgICAgICAgfCBzYXZlZF9kYXRlIHwgICBzYXZlZF90 aW1lDQotLS0tLS0tLS0tLSstLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tKy0tLS0tLS0t LS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0rLS0tLS0tLS0tLS0tKy0tLS0tLS0tLS0tLS0tLS0t DQogICAgICAgIDIwIHwgMjAyNi0wMy0wNiAxOToyMjoxOC45OTIzODIgfCAyMDI2LTAzLTA2 IDE5OjIyOjE4Ljk5MjM4NCswMSB8IDIwMjYtMDMtMDYgfCAxOToyMjoxOC45OTIzODUNCiAg ICAgICAgMjEgfCAyMDI2LTAzLTA2IDE5OjIyOjE5Ljk5MzQ4MSB8IDIwMjYtMDMtMDYgMTk6 MjI6MTkuOTkzNDg0KzAxIHwgMjAyNi0wMy0wNiB8IDE5OjIyOjE5Ljk5MzQ4NQ0KICAgICAg ICAyMiB8IDIwMjYtMDMtMDYgMTk6MjI6MjAuOTk0NTggIHwgMjAyNi0wMy0wNiAxOToyMjoy MC45OTQ1ODMrMDEgfCAyMDI2LTAzLTA2IHwgMTk6MjI6MjAuOTk0NTg0DQogICAgICAgIDIz IHwgMjAyNi0wMy0wNiAxOToyMjoyMS45OTQ4MDMgfCAyMDI2LTAzLTA2IDE5OjIyOjIxLjk5 NDgwNiswMSB8IDIwMjYtMDMtMDYgfCAxOToyMjoyMS45OTQ4MDYNCiAgICAgICAgMjQgfCAy MDI2LTAzLTA2IDE5OjIyOjIyLjk5NTkxOCB8IDIwMjYtMDMtMDYgMTk6MjI6MjIuOTk1OTIr MDEgIHwgMjAyNi0wMy0wNiB8IDE5OjIyOjIyLjk5NTkyMQ0KICAgICAgICAyNSB8IDIwMjYt MDMtMDYgMTk6MjI6MjMuOTk3MDQ5IHwgMjAyNi0wMy0wNiAxOToyMjoyMy45OTcwNTErMDEg fCAyMDI2LTAzLTA2IHwgMTk6MjI6MjMuOTk3MDUyDQogICAgICAgIDI2IHwgMjAyNi0wMy0w NiAxOToyMjoyNC45OTc4MDcgfCAyMDI2LTAzLTA2IDE5OjIyOjI0Ljk5NzgwOSswMSB8IDIw MjYtMDMtMDYgfCAxOToyMjoyNC45OTc4MDkNCiAgICAgICAgMjcgfCAyMDI2LTAzLTA2IDE5 OjIyOjI1Ljk5ODkyMyB8IDIwMjYtMDMtMDYgMTk6MjI6MjUuOTk4OTI2KzAxIHwgMjAyNi0w My0wNiB8IDE5OjIyOjI1Ljk5ODkyNw0KDQoNCg0KRnJldW5kbGljaGUgR3LDvMOfZQ0KDQpp LiBBLiBSYW1hY2hhbmRyYW4gU3VicmFtYW5pYW4NClplbnRyYWxiZXJlaWNoIEluZm9ybWF0 aW9uc3RlY2hub2xvZ2llDQoNCkFsdGUgTGVpcHppZ2VyIExlYmVuc3ZlcnNpY2hlcnVuZyBh LkcuDQoNCg0KSGFsbGVzY2hlIEtyYW5rZW52ZXJzaWNoZXJ1bmcgYS5HLg0KDQoNCg0KDQoN Cg0KDQpBbHRlIExlaXB6aWdlciBMZWJlbnN2ZXJzaWNoZXJ1bmcgYS5HLiwgQWx0ZSBMZWlw emlnZXItUGxhdHogMSwgNjE0NDAgT2JlcnVyc2VsDQpWb3JzLiBkZXMgQXVmc2ljaHRzcmF0 czogRHIuIFdhbHRlciBCb3Rlcm1hbm4gwrcgVm9yc3RhbmQ6IENocmlzdG9waCBCb2huIChW b3JzLiksIERyLiBKw7xyZ2VuIEJpZXJiYXVtIChzdHYuIFZvcnMuKSwgRnJhbmsgS2V0dG5h a2VyLCBEci4gSm9jaGVuIEtyaWVnbWVpZXIsIEFsZXhhbmRlciBNYXllciwgQ2hyaXN0aWFu IFBhcGUsIFdpbHRydWQgUGVrYXJlaywgVWRvIFdpbGNzZWsNClNpdHogT2JlcnVyc2VsIChU YXVudXMpIMK3IFJlY2h0c2Zvcm0gVlZhRyDCtyBBbXRzZ2VyaWNodCBCYWQgSG9tYnVyZyB2 LiBkLiBILiBIUkIgMTU4MyDCtyBVU3QuLUlkTnIuIERFIDExNDEwNjgxNA0KDQoNCg0KDQoN CiANCkhhbGxlc2NoZSBLcmFua2VudmVyc2ljaGVydW5nIGEuRy4sICBMw7ZmZmVsc3RyYcOf ZSAzNC0zOCwgNzA1OTcgU3R1dHRnYXJ0DQpWb3JzLiBkZXMgQXVmc2ljaHRzcmF0czogRHIu IFdhbHRlciBCb3Rlcm1hbm4gwrcgVm9yc3RhbmQ6IENocmlzdG9waCBCb2huIChWb3JzLiks IERyLiBKw7xyZ2VuIEJpZXJiYXVtIChzdHYuIFZvcnMuKSwgRnJhbmsgS2V0dG5ha2VyLCBE ci4gSm9jaGVuIEtyaWVnbWVpZXIsIEFsZXhhbmRlciBNYXllciwgQ2hyaXN0aWFuIFBhcGUs DQpXaWx0cnVkIFBla2FyZWssIFVkbyBXaWxjc2VrDQpTaXR6IFN0dXR0Z2FydCDCtyBSZWNo dHNmb3JtIFZWYUcgwrcgQW10c2dlcmljaHQgU3R1dHRnYXJ0IEhSQiAyNjg2IMK3IFVTdC4t SWROci4gREUgMTQ3ODAyMjg1DQpCZWl0csOkZ2UgenUgcHJpdmF0ZW4gS3Jhbmtlbi0gdW5k IFBmbGVnZWtyYW5rZW52ZXJzaWNoZXJ1bmdlbiB1bnRlcmxpZWdlbiBuaWNodCBkZXIgVmVy c2ljaGVydW5nc3RldWVyICjCpyA0IE5yLiA1IFZlcnNTdEcpIMK3IFZlcnNpY2hlcnVuZ3Ns ZWlzdHVuZ2VuIHNvd2llIFVtc8OkdHplIGF1cyBWZXJzaWNoZXJ1bmdzdmVydHJldGVyLS9N YWtsZXJ0w6R0aWdrZWl0ZW4gc2luZCB1bXNhdHpzdGV1ZXJmcmVpDQogDQoNCg0KDQogDQpE aWUgUGZsaWNodGFuZ2FiZW4gZGVyIEFMSCBHcnVwcGUgZ2Vtw6TDnyDCpyAzNWEgR21iSEcg Ynp3LiDCpyA4MCBBa3RHIGZpbmRlbiBTaWUgaGllcjogaHR0cHM6Ly93d3cuYWx0ZS1sZWlw emlnZXIuZGUvaW1wcmVzc3VtIA0KDQoNCg0KDQoNCl9fX19fX19fX19fX19fX19fX19fX18N Cg0KQUxIIEdydXBwZQ0KQWx0ZSBMZWlwemlnZXItUGxhdHogMSwgNjE0NDAgT2JlcnVyc2Vs DQpUZWwuOiArNDkgKDYxNzEpIDY2LTQ4ODINCkZheDogKzQ5ICg2MTcxKSA2Ni04MDAtNDg4 Mg0KRS1NYWlsOiByYW1hY2hhbmRyYW4uc3VicmFtYW5pYW5AYWx0ZS1sZWlwemlnZXIuZGUN Cnd3dy5hbHRlLWxlaXB6aWdlci5kZQ0Kd3d3LmhhbGxlc2NoZS5kZQ0KDQoNCg0KLS0tLS1V cnNwcsO8bmdsaWNoZSBOYWNocmljaHQtLS0tLQ0KVm9uOiBMYXVyZW56IEFsYmUgPGxhdXJl bnouYWxiZUBjeWJlcnRlYy5hdD4gDQpHZXNlbmRldDogRnJlaXRhZywgNi4gTcOkcnogMjAy NiAxNDoyMQ0KQW46IFN1YnJhbWFuaWFuLFJhbWFjaGFuZHJhbiBJVC1tZC1kYiA8cmFtYWNo YW5kcmFuLnN1YnJhbWFuaWFuQGFsdGUtbGVpcHppZ2VyLmRlPjsgcGdzcWwtbm92aWNlQGxp c3RzLnBvc3RncmVzcWwub3JnDQpCZXRyZWZmOiBSZTogU1FMIC0gSG93IHRvIGl0ZXJhdGUg d2l0aCBkZWxheSBpbiBhIGxvb3ANCg0KT24gRnJpLCAyMDI2LTAzLTA2IGF0IDEyOjA3ICsw MDAwLCBTdWJyYW1hbmlhbixSYW1hY2hhbmRyYW4gd3JvdGU6DQo+IEkgYW0gdHJ5aW5nIHRv IGluc2VydCBzb21lIHJvd3MgaW50byBhIHRhYmxlIHdpdGggYSBkZWxheSBiZXR3ZWVuIGVh Y2ggaW5zZXJ0Lg0KPiBJIGhhdmUgYSBzaW1wbGUgdGFibGUgd2l0aCBhIElEIGNvbHVtbiBh bmQgc29tZSBEYXRlLVRpbWUgY29sdW1ucy4NCj4gwqANCj4gVGhlIGZpcnN0IHR3byBpbnNl cnRzIHdvcmsgYXMgZXhwZWN0ZWQgYW5kIGluc2VydCB0d28gcm93cywgZWFjaCBvbmUgc2Vj b25kIGFwYXJ0Lg0KPiDCoA0KPiBIb3dldmVyIHRoZSBkbyBsb29wIGluc2VydHMgMjUgbW9y ZSByb3dzLCB3aXRoIHRoZSBzYW1lIHRpbWVzdGFtcC4NCg0KVXNlIGNsb2NrX3RpbWVzdGFt cCgpOjp0aW1lIGluc3RlYWQgb2YgY3VycmVudF90aW1lLg0KY3VycmVudF90aW1lIHJldHVy bnMgdGhlIHNhbWUgdmFsdWUgZm9yIGVhY2ggY2FsbCBpbiB0aGUgc2FtZSBkYXRhYmFzZSB0 cmFuc2FjdGlvbi4gIFRoaW5rIG9mIGl0IGFzICJ0cmFuc2FjdGlvbiBzdGFydCB0aW1lIi4N Cg0KWW91cnMsDQpMYXVyZW56IEFsYmUNCg==