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.94.2) (envelope-from ) id 1rtZ6Y-00Fhvv-C5 for pgsql-committers@arkaria.postgresql.org; Sun, 07 Apr 2024 20:27:06 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.94.2) (envelope-from ) id 1rtZ6W-00Bicv-Ie for pgsql-committers@arkaria.postgresql.org; Sun, 07 Apr 2024 20:27:04 +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.94.2) (envelope-from ) id 1rtZ6W-00Bicn-Bb for pgsql-committers@lists.postgresql.org; Sun, 07 Apr 2024 20:27:04 +0000 Received: from mahout.postgresql.org ([2001:4800:3e1:1::227]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1rtZ6P-001RbP-71 for pgsql-committers@lists.postgresql.org; Sun, 07 Apr 2024 20:27:03 +0000 Received: from gemulon.postgresql.org ([2001:4800:3e1:1::198]) by mahout.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1rtZ6M-0035kq-R8 for pgsql-committers@lists.postgresql.org; Sun, 07 Apr 2024 20:26:55 +0000 Received: from localhost ([127.0.0.1] helo=gemulon.postgresql.org) by gemulon.postgresql.org with esmtp (Exim 4.94.2) (envelope-from ) id 1rtZ6M-0011B9-0A for pgsql-committers@lists.postgresql.org; Sun, 07 Apr 2024 20:26:54 +0000 Content-Type: multipart/mixed; boundary="===============8377854763314638868==" MIME-Version: 1.0 From: Tom Lane To: pgsql-committers@lists.postgresql.org Subject: pgsql: Doc: show how to get the equivalent of LIMIT for UPDATE/DELETE. X-Auto-Response-Suppress: All Auto-Submitted: auto-generated Message-Id: Date: Sun, 07 Apr 2024 20:26:54 +0000 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --===============8377854763314638868== Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: base64 RG9jOiBzaG93IGhvdyB0byBnZXQgdGhlIGVxdWl2YWxlbnQgb2YgTElNSVQgZm9yIFVQREFURS9E RUxFVEUuCgpBZGQgZXhhbXBsZXMgc2hvd2luZyB1c2Ugb2YgYSBDVEUgYW5kIGEgc2VsZi1qb2lu IHRvIHBlcmZvcm0KcGFydGlhbCBVUERBVEVzIGFuZCBERUxFVEVzLgoKQ29yZXkgSHVpbmtlciwg cmV2aWV3ZWQgYnkgTGF1cmVueiBBbGJlCgpEaXNjdXNzaW9uOiBodHRwczovL3Bvc3Rnci5lcy9t L0NBRGtMTT1jYU5FUXNVd1BXbmZpMmpSNGl4OTlFMEVKTV8zanRjRS1Zam5FUUM3UnNzd0BtYWls LmdtYWlsLmNvbQoKQnJhbmNoCi0tLS0tLQptYXN0ZXIKCkRldGFpbHMKLS0tLS0tLQpodHRwczov L2dpdC5wb3N0Z3Jlc3FsLm9yZy9wZy9jb21taXRkaWZmLzJkYWViYTZhNGU0OWYyYWM0Y2MyMDJm YzkzNTJjMmE1OWU5MjhhNmMKCk1vZGlmaWVkIEZpbGVzCi0tLS0tLS0tLS0tLS0tCmRvYy9zcmMv c2dtbC9yZWYvZGVsZXRlLnNnbWwgfCAyNCArKysrKysrKysrKysrKysrKysrKysrLS0KZG9jL3Ny Yy9zZ21sL3JlZi91cGRhdGUuc2dtbCB8IDQwICsrKysrKysrKysrKysrKysrKysrKysrKysrKysr KysrKysrKysrKy0KMiBmaWxlcyBjaGFuZ2VkLCA2MSBpbnNlcnRpb25zKCspLCAzIGRlbGV0aW9u cygtKQoK --===============8377854763314638868==--