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 1vS1km-00FHDi-26 for pgsql-committers@arkaria.postgresql.org; Sat, 06 Dec 2025 23:31:52 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.96) (envelope-from ) id 1vS1kk-00CcGR-1V for pgsql-committers@arkaria.postgresql.org; Sat, 06 Dec 2025 23:31:50 +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 1vS1kk-00CcGJ-0n for pgsql-committers@lists.postgresql.org; Sat, 06 Dec 2025 23:31:50 +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.96) (envelope-from ) id 1vS1ki-003ZsX-0r for pgsql-committers@lists.postgresql.org; Sat, 06 Dec 2025 23:31:50 +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.96) (envelope-from ) id 1vS1kf-006CB7-1R for pgsql-committers@lists.postgresql.org; Sat, 06 Dec 2025 23:31:45 +0000 Received: from localhost ([127.0.0.1] helo=gemulon.postgresql.org) by gemulon.postgresql.org with esmtp (Exim 4.96) (envelope-from ) id 1vS1kc-003AmM-2e for pgsql-committers@lists.postgresql.org; Sat, 06 Dec 2025 23:31:43 +0000 Content-Type: multipart/mixed; boundary="===============0467387753523166897==" MIME-Version: 1.0 From: Tom Lane To: pgsql-committers@lists.postgresql.org Subject: pgsql: Handle constant inputs to corr() and related aggregates more pre X-Auto-Response-Suppress: All Auto-Submitted: auto-generated Message-Id: Date: Sat, 06 Dec 2025 23:31:43 +0000 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --===============0467387753523166897== Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: base64 SGFuZGxlIGNvbnN0YW50IGlucHV0cyB0byBjb3JyKCkgYW5kIHJlbGF0ZWQgYWdncmVnYXRlcyBt b3JlIHByZWNpc2VseS4KClRoZSBTUUwgc3RhbmRhcmQgc2F5cyB0aGF0IGNvcnIoKSBhbmQgZnJp ZW5kcyBzaG91bGQgcmV0dXJuIE5VTEwgaW4KdGhlIG1hdGhlbWF0aWNhbGx5LXVuZGVmaW5lZCBj YXNlIHdoZXJlIGFsbCB0aGUgaW5wdXRzIGluIG9uZSBvZgp0aGUgY29sdW1ucyBoYXZlIHRoZSBz YW1lIHZhbHVlLiAgV2Ugd2VyZSBjaGVja2luZyB0aGF0IGJ5IHNlZWluZwppZiB0aGUgc3VtcyBT eHggYW5kIFN5eSB3ZXJlIHplcm8sIGJ1dCB0aGF0IGFwcHJvYWNoIGlzIHZlcnkKdnVsbmVyYWJs ZSB0byByb3VuZG9mZiBlcnJvcjogaWYgYSBzdW0gaXMgY2xvc2UgdG8gemVybyBidXQgbm90CmV4 YWN0bHkgdGhhdCwgd2UnZCBjb21lIG91dCB3aXRoIGEgcHJldHR5IHNpbGx5IG5vbi1OVUxMIHJl c3VsdC4KCkluc3RlYWQsIGRpcmVjdGx5IHRyYWNrIHdoZXRoZXIgdGhlIGlucHV0cyBhcmUgYWxs IGVxdWFsIGJ5CnJlbWVtYmVyaW5nIHRoZSBjb21tb24gdmFsdWUgaW4gZWFjaCBjb2x1bW4uICBP bmNlIHdlIGRldGVjdAp0aGF0IGEgbmV3IGlucHV0IGlzIGRpZmZlcmVudCBmcm9tIGJlZm9yZSwg cmVwcmVzZW50IHRoYXQgYnkKc3RvcmluZyBOYU4gZm9yIHRoZSBjb21tb24gdmFsdWUuICAoQW4g b2JqZWN0aW9uIHRvIHRoaXMgc2NoZW1lCmlzIHRoYXQgaWYgdGhlIGlucHV0cyBhcmUgYWxsIE5h Tiwgd2Ugd2lsbCBjb25zaWRlciB0aGF0IHRoZXkKd2VyZSBub3QgYWxsIGVxdWFsLiAgQnV0IHVu ZGVyIElFRUUgZmxvYXQgYXJpdGhtZXRpYyBydWxlcywKb25lIE5hTiBpcyBuZXZlciBlcXVhbCB0 byBhbm90aGVyLCBzbyB0aGlzIGJlaGF2aW9yIGlzIGFyZ3VhYmx5CmNvcnJlY3QuICBNb3Jlb3Zl ciBpdCBtYXRjaGVzIHdoYXQgd2UgZGlkIGJlZm9yZSBpbiBzdWNoIGNhc2VzLikKVGhlbiwgbGVh dmUgdGhlIHN1bXMgYXQgdGhlaXIgZXhhY3QgdmFsdWUgb2YgemVybyBmb3IgYXMgbG9uZwphcyB3 ZSBoYXZlbid0IGRldGVjdGVkIGRpZmZlcmVudCBpbnB1dCB2YWx1ZXMuCgpUaGlzIHNvbHV0aW9u IHJlcXVpcmVzIHRoZSBhZ2dyZWdhdGUgdHJhbnNpdGlvbiBzdGF0ZSB0byBjb250YWluCjggZmxv YXQgdmFsdWVzIG5vdCA2LCB3aGljaCBpcyBub3QgcHJvYmxlbWF0aWMsIGFuZCBpdCBzZWVtcyB0 byBhZGQKbGVzcyB0aGFuIDElIHRvIHRoZSBhZ2dyZWdhdGVzJyBydW50aW1lLCB3aGljaCBzZWVt cyBhY2NlcHRhYmxlLgoKV2hpbGUgd2UncmUgaGVyZSwgaW1wcm92ZSBjb3JyKCkncyBmaW5hbCBm dW5jdGlvbiB0byBjb3BlIHdpdGgKb3ZlcmZsb3cvdW5kZXJmbG93IGluIHRoZSBmaW5hbCBjYWxj dWxhdGlvbiwgYW5kIHRvIGNsYW1wIGl0cwpyZXN1bHQgdG8gWy0xLCAxXSBpbiBjYXNlIG9mIHJv dW5kb2ZmIGVycm9yLgoKQWx0aG91Z2ggdGhpcyBpcyBhcmd1YWJseSBhIGJ1ZyBmaXgsIGl0IHJl cXVpcmVzIGEgY2F0dmVyc2lvbiBidW1wCmR1ZSB0byB0aGUgY2hhbmdlIGluIGFnZ3JlZ2F0ZXMn IGluaXRpYWwgc3RhdGVzLCBzbyBpdCBjYW4ndCBiZQpiYWNrLXBhdGNoZWQuCgpQYXRjaCB3cml0 dGVuIGJ5IG1lLCBidXQgbWFueSBvZiB0aGUgaWRlYXMgYXJlIGR1ZSB0byBEZWFuIFJhc2hlZWQs CndobyBhbHNvIGRpZCBhIGRlYWwgb2YgdGVzdGluZy4KCkJ1ZzogIzE5MzQwClJlcG9ydGVkLWJ5 OiBPbGVnIEl2YW5vdiA8bzE1NjExQGdtYWlsLmNvbT4KQXV0aG9yOiBUb20gTGFuZSA8dGdsQHNz cy5wZ2gucGEudXM+CkNvLWF1dGhvcmVkLWJ5OiBEZWFuIFJhc2hlZWQgPGRlYW4uYS5yYXNoZWVk QGdtYWlsLmNvbT4KRGlzY3Vzc2lvbjogaHR0cHM6Ly9wb3N0Z3IuZXMvbS8xOTM0MC02ZmI5ZjY2 MzdmNTYyMDkyQHBvc3RncmVzcWwub3JnCgpCcmFuY2gKLS0tLS0tCm1hc3RlcgoKRGV0YWlscwot LS0tLS0tCmh0dHBzOi8vZ2l0LnBvc3RncmVzcWwub3JnL3BnL2NvbW1pdGRpZmYvNjQ5ODI4NzY5 NmRhZmMxZWJkMzgwZWE0ZWIyNDkxMjQ5ODkyOTRkMwoKTW9kaWZpZWQgRmlsZXMKLS0tLS0tLS0t LS0tLS0Kc3JjL2JhY2tlbmQvdXRpbHMvYWR0L2Zsb2F0LmMgICAgICAgICAgICB8IDE2NSArKysr KysrKysrKysrKysrKysrKysrKysrLS0tLS0tCnNyYy9pbmNsdWRlL2NhdGFsb2cvY2F0dmVyc2lv bi5oICAgICAgICAgfCAgIDIgKy0Kc3JjL2luY2x1ZGUvY2F0YWxvZy9wZ19hZ2dyZWdhdGUuZGF0 ICAgICB8ICAyMiArKy0tLQpzcmMvdGVzdC9yZWdyZXNzL2V4cGVjdGVkL2FnZ3JlZ2F0ZXMub3V0 IHwgIDk0ICsrKysrKysrKysrKysrLS0tLQpzcmMvdGVzdC9yZWdyZXNzL3NxbC9hZ2dyZWdhdGVz LnNxbCAgICAgIHwgIDMyICsrKystLQo1IGZpbGVzIGNoYW5nZWQsIDI0OCBpbnNlcnRpb25zKCsp LCA2NyBkZWxldGlvbnMoLSkKCg== --===============0467387753523166897==--