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 1ujoLv-00CGqe-Nm for pgsql-general@arkaria.postgresql.org; Thu, 07 Aug 2025 00:19:28 +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 1ujoLu-001ohd-IQ for pgsql-general@arkaria.postgresql.org; Thu, 07 Aug 2025 00:19:26 +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 1ujoLu-001ohM-4B for pgsql-general@lists.postgresql.org; Thu, 07 Aug 2025 00:19:26 +0000 Received: from mail-oo1-xc30.google.com ([2607:f8b0:4864:20::c30]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.96) (envelope-from ) id 1ujoLr-00185h-1R for pgsql-general@lists.postgresql.org; Thu, 07 Aug 2025 00:19:25 +0000 Received: by mail-oo1-xc30.google.com with SMTP id 006d021491bc7-61994f145fbso124887eaf.0 for ; Wed, 06 Aug 2025 17:19:24 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20230601; t=1754525964; x=1755130764; darn=lists.postgresql.org; h=cc:to:subject:message-id:date:from:in-reply-to:references :mime-version:from:to:cc:subject:date:message-id:reply-to; bh=+W1U0NMq2MSCxiZRs/xg8c1v8pewxlxMraKytNmOkpA=; b=BoN8hYyQsi02k1LMdJ05Xu0scPMyHnV6a7LQIt9dJ5DJeyMjujm5vhznrbjfWMIpUg olXn7HNJiuxcIyjvv9pbajCYPpq/qUTDnRrskq011r1xM2hgCfWgYgDqSPTNj+yKm+6E wuDYohO47y1ZJMR8O3seN2zYbz+Tx1dswpJdQ3aANJOGLaoU284bHhi4kwBOzRjqhwyS GAo5GYPXuHmGupnBVsS4QVTlFNXcfU7bhIs+qZgeHXFS9nRVySSJBquLJ0w1QKP3n37o aN9XbOKNbKZmxxe9s6FJcc2Q75PlBuod3hfNtCMo7ayiEt6asc61Ajvnr4vDAcxoie9Q z7Dw== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1754525964; x=1755130764; h=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=+W1U0NMq2MSCxiZRs/xg8c1v8pewxlxMraKytNmOkpA=; b=Ha8OAy6P8cdcUQKB8OA1y3uQa7ZcTivILRqOrWGD1eMA7+O7iBI7AyCXf1uJ42iEkq RxXsfKfHd2UIWJw7dFB8KzYusmq9WC8F1yIpBJ6LLy6KRqg3ScZoACX/QmgrC93Ze2Zw Hwz7u6uq1HD/dGvxhf9PJlzASWUkKsyBz9DjtFRdz5MWZ1YYxzCyk7zerQ0o78KvrQyX CGxV1cgorZ/r6jUNhJe6Kn0YAQ3u/0D0/kbJq/cjcNR4Cxn7/8DagNTHnSAlmBPQtvjn hfEsUZ+x7nkcW3LEqWTp0uCFlvgPkjE6YHfJxT1IJnT1nIpxqoyOE0ixQo++tMOihehe DpgA== X-Forwarded-Encrypted: i=1; AJvYcCXyBrdC8IqH9oKlA8NN1ZVhFoneJ0J8+L865lH9aImtYOrE4vdfP9bU96vbay/La4e0JRPq9a+Qe1kPYrNa@lists.postgresql.org X-Gm-Message-State: AOJu0YzRNM4mHisfec7IkJzj6BbPDpm6tF2CIWLDzSvYW95U2wv1ygyY W5QAeRhpvrt7c/eJ+MkpLxrJZfl6yg5EWkF2j6fRomhnEAf4bsWBd8b+mVWowdRz8RrQjDa6ilt mXabaPjQeLqGLALu0fHMOr9AtinxGw/g= X-Gm-Gg: ASbGnctiyBbeUJSENLthq9giYBRT9br4MDqtdJ+gQzI9IMFU1cpdiEVDK4aSPJ9wJvM 1v2O4mUBYidPf+nhmVe7WcwAe6U7WUPwoT9Q9HJKRMwiamL6oX4nPmooc/gOEAnDuAEJd7bFWAk 3MNzsaFd1gcEiVEhoeCMJ/V+IvpY3NUa6Yo9v5cByLG8xMk8R0/NbAa65P87qeS/tPPJ4O80xH+ gT1rKtW5E/Jqm9VP0l21VD6lEa31xqSgRs0nNEb X-Google-Smtp-Source: AGHT+IE/Vn8bOPstfvq1bHkSBILHb5tleOs+fvOqyUxeJdlZF5re4TThzAcg+mkYZn+EowycTbd5Iu4MNwndWmWe4MY= X-Received: by 2002:a05:6820:999:b0:615:b2c9:7ffd with SMTP id 006d021491bc7-61b5f0abc47mr2888823eaf.0.1754525963650; Wed, 06 Aug 2025 17:19:23 -0700 (PDT) MIME-Version: 1.0 References: <1934172.1753462470@sss.pgh.pa.us> <1936547.1753463422@sss.pgh.pa.us> <1940680.1753465819@sss.pgh.pa.us> <1943137.1753467040@sss.pgh.pa.us> <2223785.1753476729@sss.pgh.pa.us> In-Reply-To: From: "David G. Johnston" Date: Wed, 6 Aug 2025 17:18:47 -0700 X-Gm-Features: Ac12FXwSOUyYEywCB3JlRN9EVenuYokncAzlMQM67Vb0vmIUJCWvHnSMY-LdZjg Message-ID: Subject: Re: PostgreSQL Bug with simple function unexpectedly treating varchar parameter as an array To: Rumpi Gravenstein Cc: Tom Lane , Laurenz Albe , PostgreSQL Content-Type: multipart/alternative; boundary="000000000000d00ea1063bbb68d3" List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --000000000000d00ea1063bbb68d3 Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: quoted-printable On Wed, Aug 6, 2025 at 2:39=E2=80=AFPM Rumpi Gravenstein wrote: > That having a table and function with similar names causes this problem i= s > a bug. > > Arguably. But it seems likely it's one we are not going to fix. David J. --000000000000d00ea1063bbb68d3 Content-Type: text/html; charset="UTF-8" Content-Transfer-Encoding: quoted-printable
On Wed, Aug 6, 2025 at 2:39=E2=80=AFPM Rumpi Gravenstein &= lt;rgravens@gmail.com> wrote:<= /span>
That having a ta= ble and function with similar names causes this problem is a bug.

<= /div>

Arguably.=C2=A0 But it seems li= kely it's one we are not going to fix.

David J.

--000000000000d00ea1063bbb68d3--