Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1mSLcU-0004Zm-NK for pgsql-sql@arkaria.postgresql.org; Mon, 20 Sep 2021 15:54:14 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1mSLcT-0004TZ-6y for pgsql-sql@arkaria.postgresql.org; Mon, 20 Sep 2021 15:54:13 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1mSLcS-0004TQ-SM for pgsql-sql@lists.postgresql.org; Mon, 20 Sep 2021 15:54:12 +0000 Received: from mail-ed1-x532.google.com ([2a00:1450:4864:20::532]) by magus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_128_GCM_SHA256:128) (Exim 4.92) (envelope-from ) id 1mSLcM-0002Sb-Fo for pgsql-sql@lists.postgresql.org; Mon, 20 Sep 2021 15:54:12 +0000 Received: by mail-ed1-x532.google.com with SMTP id v22so58491789edd.11 for ; Mon, 20 Sep 2021 08:54:06 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20210112; h=date:subject:message-id:importance:from:to:cc:mime-version; bh=a7YbtbncQyku1ZZ/hHQ3qh8yF5uEHTDC4Q5ekZgZH/U=; b=dR370pwbdX/+ta3NMjrYQ0RfBsFawHHnKyrbvcrBkMKDu5ozMJA3Q7bv1cOmzaoPh4 holNrd7k0Xg6UVcPxo1/UvR7q+8ingNp84lXFIyyFdZ0kiX9Y2PlOPLJ+XNgPrqeBUF/ JFMWsw6keg8RbUUqhOW3lk/ZJJb5J0Jn06IrGTpLVHl61HRhcsUYshjPBwV3qLwsKFtG wTU9POHya1FcEspGasSrHZviasMqBAcY/6dmeg/ztnJPj7zairMwRyd1s6Z6a6/2MV61 efS7402OS7+q/nPnL0rgI5myQQpG05uwi4EL/15CIalQQ2DXdLhfHiX3rKmU4n3dXz+t gbrA== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20210112; h=x-gm-message-state:date:subject:message-id:importance:from:to:cc :mime-version; bh=a7YbtbncQyku1ZZ/hHQ3qh8yF5uEHTDC4Q5ekZgZH/U=; b=o5BWdpfnpaIT7xLDjhJk0NKoKJRwVXsL7L+4+wB3P175TsKbE8BtYPbVeaAgBSCjyr TgDx7DkCLfd6Nr/X3xyyvNn4cSYMcKWHOunlt24WbOJGlJgFJk0J3Yi/dZxv1siSlLFl qsqdPqmmuiM0hg1anrzKEoAMLK7dKjcd8yq1rvBBttR4A2ewqHYfNUZ5qAZ7KxSWOwZP mm0hsGIFoZ79KCb79azOkEuzoP6qrQ48QA8tz6P10SMWxsmrijSc4JHmF4CGigV2CM92 ymf0WjPOokkTM9+XQix9Z33CnC5qZwUXFp9L6135eXmwat9nf/EEVJ3l40updf61k08k sUyA== X-Gm-Message-State: AOAM531g+qV/2ITCQBYC1mpfAZ3w7/Puq8sVBAPmWmUugNH7ZPFUDcBN 6P7wChCGEXfUZ3eA5U04aqL7xGxBf1E= X-Google-Smtp-Source: ABdhPJw9wt0S3hLoTdJe3Lv0NH+6n+ZsXS33CwqRLfwkz3Kl8NOFbYdbml33Pl73mbdgxxJxOmGIdA== X-Received: by 2002:a17:906:c249:: with SMTP id bl9mr28911125ejb.225.1632153190333; Mon, 20 Sep 2021 08:53:10 -0700 (PDT) Received: from [10.0.0.5] ([41.77.19.27]) by smtp.gmail.com with ESMTPSA id n10sm6231241ejk.86.2021.09.20.08.53.08 (version=TLS1_2 cipher=ECDHE-RSA-AES128-GCM-SHA256 bits=128/128); Mon, 20 Sep 2021 08:53:09 -0700 (PDT) Date: Mon, 20 Sep 2021 18:53:03 +0300 Subject: Re: How to sort deleted rows with trigger. Some rows before then some rows after. Message-ID: Importance: normal From: intmail01 To: Rob Sargent Cc: pgsql-sql@lists.postgresql.org MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="--_com.android.email_26395086811850" List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk ----_com.android.email_26395086811850 Content-Type: text/plain; charset=utf-8 Content-Transfer-Encoding: base64 CkhvdyB0byB1c2UgdHJhbnNhY3Rpb24gaW4gYSB0cmlnZ2VyID8gSXQgc2VlbXMgdGhlcmUgaXMg bm8gcG9zc2liaWxpdHkgdG8gY29udHJvbCB0cmFuc2FjdGlvbiB3aXRoaW4gZnVuY3Rpb24KCgot LS0tLS0tLSBPcmlnaW5hbCBtZXNzYWdlIC0tLS0tLS0tCkZyb206IFJvYiBTYXJnZW50IDxyb2Jq c2FyZ2VudEBnbWFpbC5jb20+IApEYXRlOiAxOS8wOS8yMDIxICAyMTowMCAgKEdNVCswMzowMCkg ClRvOiBpbnRtYWlsMDFAZ21haWwuY29tIApDYzogcGdzcWwtc3FsQGxpc3RzLnBvc3RncmVzcWwu b3JnIApTdWJqZWN0OiBSZTogSG93IHRvIHNvcnQgZGVsZXRlZCByb3dzIHdpdGggdHJpZ2dlci4g U29tZSByb3dzIGJlZm9yZSB0aGVuIHNvbWUgcm93cyBhZnRlci4gCgoKCj4gT24gU2VwIDE5LCAy MDIxLCBhdCAxMTozMCBBTSwgaW50bWFpbDAxQGdtYWlsLmNvbSB3cm90ZToKPiAKPiDvu79IaSwK PiAKPiBEZWxldGluZyBzb21lIHJvd3MgaW4gbXkgdGFibGUgcmVxdWlyZSBzb21lIHJ1bGVzLiBT b21lIGtpbmQgb2Ygcm93IG11c3QKPiBiZSBkZWxldGVkIGJlZm9yZSBvdGhlcnMgaWYgbm90IGVy cm9yIG9jY3Vycy4KPiBJdCBpcyBhIHN0b2NrIG1hbmFnZW1lbnQuIENhbGN1bGF0ZWQgdGhlIHJl bWFpbnMgc3RvY2sgbXVzdCBiZSBhbHdheXMKPiBwb3NpdGl2ZSBuZXZlciBuZWdhdGl2ZS4gSWYg SSBkZWxldGUgYWxsIHJvd3MgdGhhdCBpcyBtYXJrZWQgYXMgYW4KPiBwb3NpdGl2ZSBpbnB1dCBx dWFudGl0eSB0aGVuIHRoZSBzdG9jayB3aWxsIGJlIG5lZ2F0aXZlLiBUcmlnZ2Vycwo+IGNhbGN1 bGF0ZSB0aGUgcmVtYWluaW5nIHN0b2NrIGVhY2ggdGltZSBvbmUgcm93IGlzIGRlbGV0ZWQuIEl0 IHVzZXMgIkZPUgo+IEVBQ0ggUk9XIiBvcHRpb24uCj4gCj4gSWYgc29tZW9uZSBoYXZlIHRvIGRl bGV0ZSB3aXRoIEdVaSBtYW55IHJvd3MgYW5kIHdhbnQgdG8gYXZvaWQgZXJyb3IsIGhlCj4gd2ls bCBiZSBmb3JjZWQgdG8gZGVsZXRlIG5lZ2F0aXZlIGJlZm9yZSB0aGVuIHBvc2l0aXZlIGFmdGVy LiBJdCBpcyBhCj4gd2FzdCBvZiB0aW1lIGJlY2F1c2Ugd2hlbiB0aGUgbnVtYmVyIG9mIHJvd3Mg Z3Jvd3MgdGhlIGNoYW5jZSB0byByZWRvCj4gdGhlIHRhc2sgbWFueSB0aW1lcyBkdWUgdG8gZXJy b3JzLgo+IAo+IEJlbG93IGlzIGFuIGV4YW1wbGUuIElmIHVzZXIgc2VsZWN0IGFsbCByb3dzIHRo ZW4gZGVsZXRlIHRoZW0sIGFuIGVycm9yCj4gaGFwcGVuLiBBZnRlciBkZWxldGluZyB0aGUgaW5w dXQgcXVhbnRpdHkgb2YgMjAsIHRoZSBmaXJzdCByb3cgd2lsbCBiZQo+IHdpdGggYSBzdG9jayBv ZiAtNS4KPiAKPiBUQUJMRTogdF9zdG9jawo+IERhdGU6wqDCoMKgwqDCoMKgwqDCoCBRdHk6wqDC oMKgwqAgU3RvY2s6Cj4gMjAyMS8wOS8xOcKgwqDCoCAyMMKgwqDCoCAyMAo+IDIwMjEvMDkvMjDC oMKgwqAgLTXCoMKgwqAgMTUKPiAyMDIxLzA5LzIxwqDCoMKgIDEwwqDCoMKgIDI1Cj4gMjAyMS8w OS8yMsKgwqDCoCAtOMKgwqDCoCAxNwo+IAo+IEkgdHJ5IHRvIHVzZSB0d28gdHJpZ2dlcnMgYnV0 IGl0IGRvZXMgbm90IHdvcmssIHRoZSBkZWxldGlvbiBzdGFydAo+IGFsd2F5cyB3aXRoIHRoZSBw b3NpdGl2ZSBxdWFudGl0eSAyMCBub3QgYSBuZWdhdGl2ZSBvbmU6Cj4gQ1JFQVRFIFRSSUdHRVIg ZGVsZXRlXzEgQkVGT1JFIERFTEVURSBPTiB0X3N0b2NrIEZPUiBFQUNIIFJPVyBXSEVOCj4gKG9s ZC5xdHk8MCkgRVhFQ1VURSBGVU5DVElPTiBtYWluZnVuY3Rpb24oKTsKPiBDUkVBVEUgVFJJR0dF UiBkZWxldGVfMiBCRUZPUkUgREVMRVRFIE9OIHRfc3RvY2sgRk9SIEVBQ0ggUk9XIFdIRU4KPiAo b2xkLnF0eT4wKSBFWEVDVVRFIEZVTkNUSU9OIG1haW5mdW5jdGlvbigpOwo+IAo+IElmIGEgdXNl ICJGT1IgRUFDSCBTVEFURU1FTlQiIHdpdGggdGhlIFRyYW5zaXRpb24gVGFibGVzIHdoaWNoIGNh biBoZWxwCj4gdG8gbGlzdCBhbGwgcm93cyB0byBiZSBkZWxldGVkIGJ1dCBpdCBpcyBvbmx5IGF2 YWlsYWJsZSB3aXRoICJBRlRFUiIKPiBvcGVyYXRpb24uCj4gCj4gUXVlc3Rpb246IEhvdyB0byBz ZXQgdGhlIHRyaWdnZXIgdG8gZGVsZXRlIHNvbWUgcm93cyBiZWZvcmUgYW5kIHNvbWUKPiBvdGhl ciBhZnRlciAKCkZvciBlYWNoIGJhdGNoIG9mIGRlbGV0ZXMgc2VuZCB0d28gZGVsZXRlIHN0YXRl bWVudHMgaW4gYSBzaW5nbGUgdHJhbnNhY3Rpb24uIFRoZSBmaXJzdCB3aXRoIG5lZ2F0aXZlIHZh bHVlcy4gVGhlIHNlY29uZCB3aXRoIG5vbi1uZWdhdGl2ZSB2YWx1ZXMuIAo+IFRoYW5rIHlvdQo+ IAo+IAo+IArigIvigIvigIvigIvigIvigIvigIs= ----_com.android.email_26395086811850 Content-Type: text/html; charset=utf-8 Content-Transfer-Encoding: base64 PGh0bWw+PGhlYWQ+PG1ldGEgaHR0cC1lcXVpdj0iQ29udGVudC1UeXBlIiBjb250ZW50PSJ0ZXh0 L2h0bWw7IGNoYXJzZXQ9VVRGLTgiPjwvaGVhZD48Ym9keT48ZGl2Pjxicj48L2Rpdj5Ib3cgdG8g dXNlIHRyYW5zYWN0aW9uIGluIGEgdHJpZ2dlciA/IEl0IHNlZW1zIHRoZXJlIGlzIG5vIHBvc3Np YmlsaXR5IHRvIGNvbnRyb2wgdHJhbnNhY3Rpb24gd2l0aGluIGZ1bmN0aW9uPGRpdj48YnI+PC9k aXY+PGJyPjxicj4tLS0tLS0tLSBPcmlnaW5hbCBtZXNzYWdlIC0tLS0tLS0tPGJyPkZyb206IFJv YiBTYXJnZW50ICZsdDtyb2Jqc2FyZ2VudEBnbWFpbC5jb20mZ3Q7IDxicj5EYXRlOiAxOS8wOS8y MDIxICAyMTowMCAgKEdNVCswMzowMCkgPGJyPlRvOiBpbnRtYWlsMDFAZ21haWwuY29tIDxicj5D YzogcGdzcWwtc3FsQGxpc3RzLnBvc3RncmVzcWwub3JnIDxicj5TdWJqZWN0OiBSZTogSG93IHRv IHNvcnQgZGVsZXRlZCByb3dzIHdpdGggdHJpZ2dlci4gU29tZSByb3dzIGJlZm9yZSB0aGVuIHNv bWUgcm93cyBhZnRlci4gPGJyPjxicj48YnI+PGJyPiZndDsgT24gU2VwIDE5LCAyMDIxLCBhdCAx MTozMCBBTSwgaW50bWFpbDAxQGdtYWlsLmNvbSB3cm90ZTo8YnI+Jmd0OyA8YnI+Jmd0OyDvu79I aSw8YnI+Jmd0OyA8YnI+Jmd0OyBEZWxldGluZyBzb21lIHJvd3MgaW4gbXkgdGFibGUgcmVxdWly ZSBzb21lIHJ1bGVzLiBTb21lIGtpbmQgb2Ygcm93IG11c3Q8YnI+Jmd0OyBiZSBkZWxldGVkIGJl Zm9yZSBvdGhlcnMgaWYgbm90IGVycm9yIG9jY3Vycy48YnI+Jmd0OyBJdCBpcyBhIHN0b2NrIG1h bmFnZW1lbnQuIENhbGN1bGF0ZWQgdGhlIHJlbWFpbnMgc3RvY2sgbXVzdCBiZSBhbHdheXM8YnI+ Jmd0OyBwb3NpdGl2ZSBuZXZlciBuZWdhdGl2ZS4gSWYgSSBkZWxldGUgYWxsIHJvd3MgdGhhdCBp cyBtYXJrZWQgYXMgYW48YnI+Jmd0OyBwb3NpdGl2ZSBpbnB1dCBxdWFudGl0eSB0aGVuIHRoZSBz dG9jayB3aWxsIGJlIG5lZ2F0aXZlLiBUcmlnZ2Vyczxicj4mZ3Q7IGNhbGN1bGF0ZSB0aGUgcmVt YWluaW5nIHN0b2NrIGVhY2ggdGltZSBvbmUgcm93IGlzIGRlbGV0ZWQuIEl0IHVzZXMgIkZPUjxi cj4mZ3Q7IEVBQ0ggUk9XIiBvcHRpb24uPGJyPiZndDsgPGJyPiZndDsgSWYgc29tZW9uZSBoYXZl IHRvIGRlbGV0ZSB3aXRoIEdVaSBtYW55IHJvd3MgYW5kIHdhbnQgdG8gYXZvaWQgZXJyb3IsIGhl PGJyPiZndDsgd2lsbCBiZSBmb3JjZWQgdG8gZGVsZXRlIG5lZ2F0aXZlIGJlZm9yZSB0aGVuIHBv c2l0aXZlIGFmdGVyLiBJdCBpcyBhPGJyPiZndDsgd2FzdCBvZiB0aW1lIGJlY2F1c2Ugd2hlbiB0 aGUgbnVtYmVyIG9mIHJvd3MgZ3Jvd3MgdGhlIGNoYW5jZSB0byByZWRvPGJyPiZndDsgdGhlIHRh c2sgbWFueSB0aW1lcyBkdWUgdG8gZXJyb3JzLjxicj4mZ3Q7IDxicj4mZ3Q7IEJlbG93IGlzIGFu IGV4YW1wbGUuIElmIHVzZXIgc2VsZWN0IGFsbCByb3dzIHRoZW4gZGVsZXRlIHRoZW0sIGFuIGVy cm9yPGJyPiZndDsgaGFwcGVuLiBBZnRlciBkZWxldGluZyB0aGUgaW5wdXQgcXVhbnRpdHkgb2Yg MjAsIHRoZSBmaXJzdCByb3cgd2lsbCBiZTxicj4mZ3Q7IHdpdGggYSBzdG9jayBvZiAtNS48YnI+ Jmd0OyA8YnI+Jmd0OyBUQUJMRTogdF9zdG9jazxicj4mZ3Q7IERhdGU6Jm5ic3A7Jm5ic3A7Jm5i c3A7Jm5ic3A7Jm5ic3A7Jm5ic3A7Jm5ic3A7Jm5ic3A7IFF0eTombmJzcDsmbmJzcDsmbmJzcDsm bmJzcDsgU3RvY2s6PGJyPiZndDsgMjAyMS8wOS8xOSZuYnNwOyZuYnNwOyZuYnNwOyAyMCZuYnNw OyZuYnNwOyZuYnNwOyAyMDxicj4mZ3Q7IDIwMjEvMDkvMjAmbmJzcDsmbmJzcDsmbmJzcDsgLTUm bmJzcDsmbmJzcDsmbmJzcDsgMTU8YnI+Jmd0OyAyMDIxLzA5LzIxJm5ic3A7Jm5ic3A7Jm5ic3A7 IDEwJm5ic3A7Jm5ic3A7Jm5ic3A7IDI1PGJyPiZndDsgMjAyMS8wOS8yMiZuYnNwOyZuYnNwOyZu YnNwOyAtOCZuYnNwOyZuYnNwOyZuYnNwOyAxNzxicj4mZ3Q7IDxicj4mZ3Q7IEkgdHJ5IHRvIHVz ZSB0d28gdHJpZ2dlcnMgYnV0IGl0IGRvZXMgbm90IHdvcmssIHRoZSBkZWxldGlvbiBzdGFydDxi cj4mZ3Q7IGFsd2F5cyB3aXRoIHRoZSBwb3NpdGl2ZSBxdWFudGl0eSAyMCBub3QgYSBuZWdhdGl2 ZSBvbmU6PGJyPiZndDsgQ1JFQVRFIFRSSUdHRVIgZGVsZXRlXzEgQkVGT1JFIERFTEVURSBPTiB0 X3N0b2NrIEZPUiBFQUNIIFJPVyBXSEVOPGJyPiZndDsgKG9sZC5xdHkmbHQ7MCkgRVhFQ1VURSBG VU5DVElPTiBtYWluZnVuY3Rpb24oKTs8YnI+Jmd0OyBDUkVBVEUgVFJJR0dFUiBkZWxldGVfMiBC RUZPUkUgREVMRVRFIE9OIHRfc3RvY2sgRk9SIEVBQ0ggUk9XIFdIRU48YnI+Jmd0OyAob2xkLnF0 eSZndDswKSBFWEVDVVRFIEZVTkNUSU9OIG1haW5mdW5jdGlvbigpOzxicj4mZ3Q7IDxicj4mZ3Q7 IElmIGEgdXNlICJGT1IgRUFDSCBTVEFURU1FTlQiIHdpdGggdGhlIFRyYW5zaXRpb24gVGFibGVz IHdoaWNoIGNhbiBoZWxwPGJyPiZndDsgdG8gbGlzdCBhbGwgcm93cyB0byBiZSBkZWxldGVkIGJ1 dCBpdCBpcyBvbmx5IGF2YWlsYWJsZSB3aXRoICJBRlRFUiI8YnI+Jmd0OyBvcGVyYXRpb24uPGJy PiZndDsgPGJyPiZndDsgUXVlc3Rpb246IEhvdyB0byBzZXQgdGhlIHRyaWdnZXIgdG8gZGVsZXRl IHNvbWUgcm93cyBiZWZvcmUgYW5kIHNvbWU8YnI+Jmd0OyBvdGhlciBhZnRlciA8YnI+PGJyPkZv ciBlYWNoIGJhdGNoIG9mIGRlbGV0ZXMgc2VuZCB0d28gZGVsZXRlIHN0YXRlbWVudHMgaW4gYSBz aW5nbGUgdHJhbnNhY3Rpb24uIFRoZSBmaXJzdCB3aXRoIG5lZ2F0aXZlIHZhbHVlcy4gVGhlIHNl Y29uZCB3aXRoIG5vbi1uZWdhdGl2ZSB2YWx1ZXMuIDxicj4mZ3Q7IFRoYW5rIHlvdTxicj4mZ3Q7 IDxicj4mZ3Q7IDxicj4mZ3Q7IDxicj48L2JyPjwvYm9keT48L2h0bWw+ ----_com.android.email_26395086811850--