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 1uISt5-005BJF-Ow for pgsql-hackers@arkaria.postgresql.org; Fri, 23 May 2025 13:56:39 +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 1uISt4-001u8r-6T for pgsql-hackers@arkaria.postgresql.org; Fri, 23 May 2025 13:56:37 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1uISt3-001u8j-Rg for pgsql-hackers@lists.postgresql.org; Fri, 23 May 2025 13:56:37 +0000 Received: from mail-yw1-x1135.google.com ([2607:f8b0:4864:20::1135]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.96) (envelope-from ) id 1uISt1-000WhQ-0h for pgsql-hackers@lists.postgresql.org; Fri, 23 May 2025 13:56:36 +0000 Received: by mail-yw1-x1135.google.com with SMTP id 00721157ae682-7053f85f059so79609567b3.2 for ; Fri, 23 May 2025 06:56:35 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20230601; t=1748008594; x=1748613394; darn=lists.postgresql.org; h=content-transfer-encoding:cc:to:subject:message-id:date:from :in-reply-to:references:mime-version:from:to:cc:subject:date :message-id:reply-to; bh=h+BRunB+DP+q1XQ46UR21XRreZPyLoVHYypqAGBV0Pc=; b=Add04bmmxnR8jBZ+XHXh+DvMHO+ILnPcJtsJEraKo3TXldXbMl8C2JQoQ/qHbnTyU6 P/WpEXlmvfvXJevOkYqCzeesNjjCUZ1ew6rdBDcJeiAjgXq4tEGqbYFWUB5KERLlzWuY t2y7sTR8jq4IRxoUHyxJDMvnmMKgJZZbE2oG0VRa+TDITBlMdql9npnG8M9kZaYZiwHH n6fCPfERSpU49KgbWc7RwpIrHQqp9E61K3OxsvRejvwtGlus/4HmlDYDANWsdO5A6Jtq sny46o0DfI/WLBQfrF5jn+IjDR/j0Msfb5JHgeKp8fa+/O8OFjVCYGmSqitc2lbUluaH +mrA== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1748008594; x=1748613394; h=content-transfer-encoding:cc:to:subject:message-id:date:from :in-reply-to:references:mime-version:x-gm-message-state:from:to:cc :subject:date:message-id:reply-to; bh=h+BRunB+DP+q1XQ46UR21XRreZPyLoVHYypqAGBV0Pc=; b=xLINCbWtfdQ+y66kIRAHXrTN9Msj4bfYo2d9oEw86Ek2IGpnsrpiWJ+cXbYrkQjc1o nJ0YqobeJC/zz2MPoHFyTJb4k6XHcul4UmObO6lrfPm7WR8xyirMb0qtCdTW+0gz5x2K xQwHGj0dSoxBp418va6f7SYy1C9eQ1NRTaWV2ObUHOeHqVy18m7xB1FckgjU9o2THONb fPwoUUzpAQYjNwOH1ANFfEroKcMcfYLhgc6utsRagkyApX0hIRSTicpm83xmo0apAPqH QjaFbvIiDZbluIHAZc3UAL1vXQ9G8y2wo/SggVg7DaI+q3v5eDGaDz9RcURfZDEcnXyx 83qw== X-Forwarded-Encrypted: i=1; AJvYcCUAac2AUvuVjW9RBEzz6ZgHGIT+1uJKqEIsocvq2VQI6t6YNf0zFDsYgrqBAMDlET/sERey2WFGzv6jGNAI@lists.postgresql.org X-Gm-Message-State: AOJu0Yy8QHToFs0IoL8a1zeQTGzFxgkBqXzficzx8JZhYOFAN06EaMh1 ooeEMFPagDS2bUwNhWHF0NEzkcsd3t8+p429lo828yq/A5NrwKPi1u/ykt0hf2CLhYX8DjyQHd6 25Km1/712Qnq3ZHiZDw9V7aaAk1svLxs= X-Gm-Gg: ASbGncuTAnr037mrvN12NWtxBoe6MAsvcUovZlF0bp9zs0HlyF3AznsO4vIBLbE3zQj dCZs3gf62Ho54UjUGIYAZqoioT/LPY4V7awT+Dh+FuTDvpAylhgkWVm7S4wuHgrNVSKMFasEKQs bcKrfbAP1jvHZ4qdmMAqp2oYiBDUN1gU1Q X-Google-Smtp-Source: AGHT+IFyutEDpCRwaeYdyn+7fTj/vPYPJsG6uXO70j5N+AAbkUI9ThQ46kJ/PQxJ8BHI2gvfPvoSNwUVs/AloPhnnF4= X-Received: by 2002:a05:690c:6d07:b0:702:627c:94ec with SMTP id 00721157ae682-70e198fcb2bmr39554627b3.35.1748008594432; Fri, 23 May 2025 06:56:34 -0700 (PDT) MIME-Version: 1.0 References: <145894.1727298237@sss.pgh.pa.us> <7e9debe6-4e96-4b0d-a801-b531e962ef43@eisentraut.org> In-Reply-To: <7e9debe6-4e96-4b0d-a801-b531e962ef43@eisentraut.org> From: Robert Haas Date: Fri, 23 May 2025 09:56:11 -0400 X-Gm-Features: AX0GCFuyXJonvuKkIGv845RgYCiwwg-r99J0-I3yH50V8Ekrx5I-8a8n4lQOaJc Message-ID: Subject: Re: PATCH: jsonpath string methods: lower, upper, initcap, l/r/btrim, replace, split_part To: Peter Eisentraut Cc: Florents Tselai , Alexander Korotkov , Tom Lane , pgsql-hackers , Andrew Dunstan Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: quoted-printable List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk On Thu, May 22, 2025 at 4:56=E2=80=AFPM Peter Eisentraut wrote: > I don't understand how this discussion got to the conclusion that > functions that depend on the locale cannot be immutable. Note that the > top-level functions lower, upper, and initcap themselves are immutable. Oh, well that was what Tom said last September and I just assumed he was right about the policy. If not, well then that's different. --=20 Robert Haas EDB: http://www.enterprisedb.com