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 1w2b0o-000QeD-37 for pgsql-general@arkaria.postgresql.org; Tue, 17 Mar 2026 20:27:34 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.96) (envelope-from ) id 1w2b0m-004sHN-2P for pgsql-general@arkaria.postgresql.org; Tue, 17 Mar 2026 20:27:32 +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 1w2b0m-004sHE-1K for pgsql-general@lists.postgresql.org; Tue, 17 Mar 2026 20:27:32 +0000 Received: from mail-lf1-x12d.google.com ([2a00:1450:4864:20::12d]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.98.2) (envelope-from ) id 1w2b0i-00000000fID-3yu8 for pgsql-general@postgresql.org; Tue, 17 Mar 2026 20:27:31 +0000 Received: by mail-lf1-x12d.google.com with SMTP id 2adb3069b0e04-59dea72099eso7198001e87.0 for ; Tue, 17 Mar 2026 13:27:29 -0700 (PDT) ARC-Seal: i=1; a=rsa-sha256; t=1773779248; cv=none; d=google.com; s=arc-20240605; b=IdIVoDVgsMgPijDwxcGTS2foNv3Rtx0IIj1qZDPWD4tfMIvsyXkYabZifhHHmT22xO bwNG4vQ3Kdy+fN78jUaG9xry4VYBnHEGwLVpn4dHrfnFpX0HrGx9zL2a0+yeUWi0u7Xs RkOhdu8aOq6++FaDvqmfJ0CSSS1DE4eBo6/ZG1Z/THGpTpFlCK2bc5AB/VsiaMp3lVmn +UIjIMl28PnANBxKB4KH7R5BdNQdS6DubAHVTmigkwZG3/p5nNTzKaAkZacjBzcQc+Pr jyFyxhdwsC+5K0Vcld4mOOA8+G+E1xv3z9Wa/FvHV2PFf7ndzDGxM8BETwuz904UfFJu Z5zA== ARC-Message-Signature: i=1; a=rsa-sha256; c=relaxed/relaxed; d=google.com; s=arc-20240605; h=cc:to:subject:message-id:date:from:in-reply-to:references :mime-version:dkim-signature; bh=3N2s1CYKJJAbQBurSBifZkPU7Y0M5Pd8xXfkraSnJ90=; fh=cQaUnmuwjuR9OsxDL7SxCVBwEjDYlbKL9Ym3U6WPyC4=; b=CpstTrdjduHhqcqG0Mh+FeBOOkN+H0JxYAuvVU+pGDlGIznM5ygEq92jUQiw0hxNaF ubBP3t1UXwnvX0boQ2fgaISVbYPcMl314ddxSq1NYcTbBiUyS0IgoJ5ByLd8TeOCphbf Q+p+0gZbsBw65hHBUiCdMeJCSnon+T6qhHpJskWKXmht1FlchMvFpjKoPhedVpoKBwmJ TedoznuXazHJjw++7rjNdl4/VuZ872zvYPOyxXESngqNdvwXsfpnx53+vqKfU+L4Nk/2 cpMdUy7v3fhwIc65ps5/rabyVOQ9pklI1NBmGKHMrnQndZ82gxZbVTasLI32C0sTBAcj gDRA==; darn=postgresql.org ARC-Authentication-Results: i=1; mx.google.com; arc=none DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=f10-com-br.20230601.gappssmtp.com; s=20230601; t=1773779248; x=1774384048; darn=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=3N2s1CYKJJAbQBurSBifZkPU7Y0M5Pd8xXfkraSnJ90=; b=Jt0W70dY+s3DJ3GWDEJsFsgBc8z8V9gNPO4EHGEFcvMQVPKFrCGhjZcKvA/0FYYLnR H9RKIiNQ2uZNLuUv6rqVdiY21KwMEGIiY8mXYVVKOhh89HQeaDTxSpUUttV99V/bunw3 83R/B0r2ljSfWGsxW/dAK4k6O2hxoj95Sr+Tp8suvv4KLa42OcfvSLr1nyfYCJwLYYVt aqv6G1NseR1MuOSM2qqfHXHBLDXMoe32zg02G0r40DdJS2e9JMTy1vpvYd4WqdKqwNpA BRghBOzhwxPSgR9SNfjDQSMaVTC2f3iNG5D9iiWkFpz6I5nhzRlWYakUGSwBUd27T94D y7QA== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20251104; t=1773779248; x=1774384048; h=cc:to:subject:message-id:date:from:in-reply-to:references :mime-version:x-gm-gg:x-gm-message-state:from:to:cc:subject:date :message-id:reply-to; bh=3N2s1CYKJJAbQBurSBifZkPU7Y0M5Pd8xXfkraSnJ90=; b=fNOHEhq4Mjbtn1NRDMylMA9mEFsR8sSsFQeeh12z1BJhqw271OpM6TfZN5im2xfJUl 8G3k/FE4qv3ZiIsNPR2DkwkH2yeWI5p5MKjFbn5QX2hsgdqVd8lzPI9oCnVoNvuXt8qQ xkB0WqogpTMcFWTn4zP0scoqh097ZTEjnlpyDgRK1LmU1EwBWH6EVPrTx4owa/aJFla+ ZxloS1QOmUZeW/1yW+nIHTc5TeOZ4vdMWJg6iZkwkvpXQkBhtIq4a1rKQALltf1fCVSX DKp/yzPpwJ3C+GLzxRVh/nPvZtg8MDyUm9aOeegE5L0eVwS1WEb+zhTcAuvVyItnNfmG 97+Q== X-Gm-Message-State: AOJu0YwAlj/6dqbBOwyHbGOfHzkYlp+eJGRnKzGakhtuuylTo0zG1Pvw Wo223Q5I+gbPVWBVWzqowpt/rnl21EJ6gCteN3WSzVgOaYo7SFxUKnydUzKbTc/KCHnLG6jt6qT rw0RFJl+WJtIB3zori+4hCC98om6x4gINJe1AOCnPG8zEIhwOjLiQyg== X-Gm-Gg: ATEYQzyIqqOl5f3+v3JXuSszJT1ecIk0x5ChOv1XNHjYcen8BBXMHXF1+q1jUjhXRe4 O1GXLZGu0mPYpjxbLxjHaEEoA9P6flKExK3MlwHVPcZ1GaXnA0yZHjPzkkSOpZWSSHUvEAz84Qb lHOFyQlOdxUOsUQirDL3wHq3O6jR4c+L6FNYE0jahdKrRbR1sytLeGI/XsxYCKDCder/uAgDAqR FhxNUhccScEIsy/1zlgdKqTJYLACdVWS54o7MtzVi88IyuqpQXWZB0nq8OSyiRjnc+hGAyplLSZ 7Nogm3ORhw== X-Received: by 2002:a05:6512:3da2:b0:5a2:79c5:a320 with SMTP id 2adb3069b0e04-5a279c5a4d3mr308635e87.13.1773779248432; Tue, 17 Mar 2026 13:27:28 -0700 (PDT) MIME-Version: 1.0 References: <114fe468-204a-43a9-8edc-26ffd6d598a4@aklaver.com> In-Reply-To: <114fe468-204a-43a9-8edc-26ffd6d598a4@aklaver.com> From: Marcos Pegoraro Date: Tue, 17 Mar 2026 17:26:52 -0300 X-Gm-Features: AaiRm53YrD_q_wTAfhHGDiRiNv3Onk-uPo30wbNPSHLWV-zKIs2rkzFcEKzx9ls Message-ID: Subject: Re: Trying to understand pg_get_expr() To: Adrian Klaver Cc: pgsql-general Content-Type: multipart/alternative; boundary="000000000000035404064d3e2a51" List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --000000000000035404064d3e2a51 Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: quoted-printable Em ter., 17 de mar. de 2026 =C3=A0s 17:19, Adrian Klaver < adrian.klaver@aklaver.com> escreveu: > I also tried other combinations of casting both sides of "=3D" and it > still did not work. > "'test'::character varying" is the result of that function, not type of tes= t This should work AND pg_get_expr(adbin, adrelid) =3D $$'test'::character varying$$; regards Marcos --000000000000035404064d3e2a51 Content-Type: text/html; charset="UTF-8" Content-Transfer-Encoding: quoted-printable
Em ter., 17 de m= ar. de 2026 =C3=A0s 17:19, Adrian Klaver <adrian.klaver@aklaver.com> escreveu:
I also tried other combinations of casting both sides of "=3D" an= d it
still did not work.

"'test'::character varying"= ; is the result of that function, not type of test
This should work
A= ND pg_get_expr(adbin, adrelid) =3D $$'test'::character varying$$;

regards
Marcos

<= /div>
--000000000000035404064d3e2a51--