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 1oOKj0-0006hJ-7i for pgsql-committers@arkaria.postgresql.org; Wed, 17 Aug 2022 15:12:54 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1oOKiz-0005qN-0H for pgsql-committers@arkaria.postgresql.org; Wed, 17 Aug 2022 15:12:53 +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 1oOKiy-0005qE-PC for pgsql-committers@lists.postgresql.org; Wed, 17 Aug 2022 15:12:52 +0000 Received: from mahout.postgresql.org ([2001:4800:3e1:1::227]) by magus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1oOKir-0006RQ-Mv for pgsql-committers@lists.postgresql.org; Wed, 17 Aug 2022 15:12:52 +0000 Received: from gemulon.postgresql.org ([2001:4800:3e1:1::198]) by mahout.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1oOKiq-00050I-0h for pgsql-committers@lists.postgresql.org; Wed, 17 Aug 2022 15:12:44 +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 1oOKin-001CGW-QC for pgsql-committers@lists.postgresql.org; Wed, 17 Aug 2022 15:12:43 +0000 Content-Type: multipart/mixed; boundary="===============9141299416229531156==" MIME-Version: 1.0 From: Tom Lane To: pgsql-committers@lists.postgresql.org Subject: pgsql: Avoid using list_length() to test for empty list. X-Auto-Response-Suppress: All Auto-Submitted: auto-generated Message-Id: Date: Wed, 17 Aug 2022 15:12:43 +0000 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --===============9141299416229531156== Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: base64 QXZvaWQgdXNpbmcgbGlzdF9sZW5ndGgoKSB0byB0ZXN0IGZvciBlbXB0eSBsaXN0LgoKVGhlIHN0 YW5kYXJkIHdheSB0byBjaGVjayBmb3IgbGlzdCBlbXB0aW5lc3MgaXMgdG8gY29tcGFyZSB0aGUK TGlzdCBwb2ludGVyIHRvIE5JTDsgb3VyIGxpc3QgY29kZSBnb2VzIG91dCBvZiBpdHMgd2F5IHRv IGVuc3VyZQp0aGF0IHRoYXQgaXMgdGhlIG9ubHkgcmVwcmVzZW50YXRpb24gb2YgYW4gZW1wdHkg bGlzdC4gIChBbgphY2NlcHRhYmxlIGFsdGVybmF0aXZlIGlzIGEgcGxhaW4gYm9vbGVhbiB0ZXN0 IGZvciBub24tbnVsbApwb2ludGVyLCBidXQgZXhwbGljaXQgbWVudGlvbiBvZiBOSUwgaXMgdXN1 YWxseSBwcmVmZXJhYmxlLikKClZhcmlvdXMgcGxhY2VzIGRpZG4ndCBnZXQgdGhhdCBtZW1vIGFu ZCBleHByZXNzZWQgdGhlIGNvbmRpdGlvbgp3aXRoIGxpc3RfbGVuZ3RoKCksIHdoaWNoIG1pZ2h0 IG5vdCBiZSBzbyBiYWQgZXhjZXB0IHRoYXQgdGhlcmUKd2VyZSBzdWNoIGEgdmFyaWV0eSBvZiB3 YXlzIHRvIGNoZWNrIGl0IGV4YWN0bHk6IGVxdWFsIHRvIHplcm8sCmxlc3MgdGhhbiBvciBlcXVh bCB0byB6ZXJvLCBsZXNzIHRoYW4gb25lLCB5YWRkYSB5YWRkYS4gIEluIHRoZQpuYW1lIG9mIGNv ZGUgcmVhZGFiaWxpdHksIGxldCdzIHN0YW5kYXJkaXplIGFsbCB0aG9zZSBzcGVsbGluZ3MKYXMg Imxpc3QgPT0gTklMIiBvciAibGlzdCAhPSBOSUwiLiAgKFRoZXJlJ3MgcHJvYmFibHkgc29tZQpt aWNyb3Njb3BpYyBlZmZpY2llbmN5IGdhaW4gdG9vLCB0aG91Z2ggZmV3IG9mIHRoZXNlIGxvb2sg dG8gYmUKYXQgYWxsIHBlcmZvcm1hbmNlLWNyaXRpY2FsLikKCkEgdmVyeSBzbWFsbCBudW1iZXIg b2YgY2FzZXMgd2VyZSBsZWZ0IGFzLWlzIGJlY2F1c2UgdGhleSBzZWVtZWQKbW9yZSBjb25zaXN0 ZW50IHdpdGggb3RoZXIgYWRqYWNlbnQgbGlzdF9sZW5ndGggdGVzdHMgdGhhdCB3YXkuCgpQZXRl ciBTbWl0aCwgd2l0aCBiaWtlc2hlZGRpbmcgZnJvbSBhIG51bWJlciBvZiB1cwoKRGlzY3Vzc2lv bjogaHR0cHM6Ly9wb3N0Z3IuZXMvbS9DQUh1dCtQdFFZZStFTlg1S3JPTk1mdWdmMHE2TkhnNGhS NWRBaHFFWEVjMmVlZkZlaWdAbWFpbC5nbWFpbC5jb20KCkJyYW5jaAotLS0tLS0KbWFzdGVyCgpE ZXRhaWxzCi0tLS0tLS0KaHR0cHM6Ly9naXQucG9zdGdyZXNxbC5vcmcvcGcvY29tbWl0ZGlmZi9l ZmQwYzE2YmVjYmY0NWUzYjAyMTVlMTI0ZmRlNzVmZWU4ZmNiY2U0CgpNb2RpZmllZCBGaWxlcwot LS0tLS0tLS0tLS0tLQpzcmMvYmFja2VuZC9jYXRhbG9nL29iamVjdGFkZHJlc3MuYyAgICAgICAg ICAgICAgICAgIHwgIDIgKy0Kc3JjL2JhY2tlbmQvY2F0YWxvZy9wZ19kZXBlbmQuYyAgICAgICAg ICAgICAgICAgICAgICB8ICAyICstCnNyYy9iYWNrZW5kL2NvbW1hbmRzL2V2ZW50X3RyaWdnZXIu YyAgICAgICAgICAgICAgICAgfCAgOCArKysrLS0tLQpzcmMvYmFja2VuZC9jb21tYW5kcy9mdW5j dGlvbmNtZHMuYyAgICAgICAgICAgICAgICAgIHwgIDQgKystLQpzcmMvYmFja2VuZC9jb21tYW5k cy9wdWJsaWNhdGlvbmNtZHMuYyAgICAgICAgICAgICAgIHwgIDYgKysrLS0tCnNyYy9iYWNrZW5k L2NvbW1hbmRzL3N0YXRzY21kcy5jICAgICAgICAgICAgICAgICAgICAgfCAgNCArKy0tCnNyYy9i YWNrZW5kL2NvbW1hbmRzL3N1YnNjcmlwdGlvbmNtZHMuYyAgICAgICAgICAgICAgfCAgMiArLQpz cmMvYmFja2VuZC9jb21tYW5kcy90YWJsZWNtZHMuYyAgICAgICAgICAgICAgICAgICAgIHwgIDgg KysrKy0tLS0Kc3JjL2JhY2tlbmQvY29tbWFuZHMvdHlwZWNtZHMuYyAgICAgICAgICAgICAgICAg ICAgICB8ICAyICstCnNyYy9iYWNrZW5kL2V4ZWN1dG9yL2V4ZWNQYXJ0aXRpb24uYyAgICAgICAg ICAgICAgICAgfCAgMiArLQpzcmMvYmFja2VuZC9saWJwcS9hdXRoLmMgICAgICAgICAgICAgICAg ICAgICAgICAgICAgIHwgIDQgKystLQpzcmMvYmFja2VuZC9saWJwcS9oYmEuYyAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgIHwgIDQgKystLQpzcmMvYmFja2VuZC9vcHRpbWl6ZXIvcGF0aC9j b3N0c2l6ZS5jICAgICAgICAgICAgICAgIHwgIDIgKy0Kc3JjL2JhY2tlbmQvb3B0aW1pemVyL3Bs YW4vY3JlYXRlcGxhbi5jICAgICAgICAgICAgICB8ICAyICstCnNyYy9iYWNrZW5kL29wdGltaXpl ci9wbGFuL3BsYW5uZXIuYyAgICAgICAgICAgICAgICAgfCAxMiArKysrKystLS0tLS0Kc3JjL2Jh Y2tlbmQvcGFydGl0aW9uaW5nL3BhcnRwcnVuZS5jICAgICAgICAgICAgICAgICB8ICAyICstCnNy Yy9iYWNrZW5kL3JlcGxpY2F0aW9uL2xvZ2ljYWwvdGFibGVzeW5jLmMgICAgICAgICAgfCAgOCAr KysrLS0tLQpzcmMvYmFja2VuZC9yZXBsaWNhdGlvbi9wZ291dHB1dC9wZ291dHB1dC5jICAgICAg ICAgIHwgIDIgKy0Kc3JjL2JhY2tlbmQvcmV3cml0ZS9yZXdyaXRlRGVmaW5lLmMgICAgICAgICAg ICAgICAgICB8ICAyICstCnNyYy9iYWNrZW5kL3N0YXRpc3RpY3MvbWN2LmMgICAgICAgICAgICAg ICAgICAgICAgICAgfCAgMSAtCnNyYy9iYWNrZW5kL3N0b3JhZ2UvbG1nci9sbWdyLmMgICAgICAg ICAgICAgICAgICAgICAgfCAgMiArLQpzcmMvYmFja2VuZC91dGlscy9hZHQvanNvbmJfZ2luLmMg ICAgICAgICAgICAgICAgICAgIHwgIDIgKy0Kc3JjL2JhY2tlbmQvdXRpbHMvYWR0L2pzb25wYXRo X2V4ZWMuYyAgICAgICAgICAgICAgICB8ICAyICstCnNyYy9iYWNrZW5kL3V0aWxzL2FkdC9qc29u cGF0aF9ncmFtLnkgICAgICAgICAgICAgICAgfCAgMiArLQpzcmMvYmFja2VuZC91dGlscy9hZHQv cnVsZXV0aWxzLmMgICAgICAgICAgICAgICAgICAgIHwgIDIgKy0Kc3JjL2JhY2tlbmQvdXRpbHMv YWR0L3NlbGZ1bmNzLmMgICAgICAgICAgICAgICAgICAgICB8ICAyICstCnNyYy9iYWNrZW5kL3V0 aWxzL2FkdC90c3F1ZXJ5LmMgICAgICAgICAgICAgICAgICAgICAgfCAgMiArLQpzcmMvdGVzdC9t b2R1bGVzL3Rlc3RfZGRsX2RlcGFyc2UvdGVzdF9kZGxfZGVwYXJzZS5jIHwgIDIgKy0KMjggZmls ZXMgY2hhbmdlZCwgNDcgaW5zZXJ0aW9ucygrKSwgNDggZGVsZXRpb25zKC0pCgo= --===============9141299416229531156==--