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 1w2amU-000QSE-34 for pgsql-general@arkaria.postgresql.org; Tue, 17 Mar 2026 20:12:47 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.96) (envelope-from ) id 1w2amT-004o2I-30 for pgsql-general@arkaria.postgresql.org; Tue, 17 Mar 2026 20:12:45 +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.96) (envelope-from ) id 1w2ajO-004kZ2-2q for pgsql-general@lists.postgresql.org; Tue, 17 Mar 2026 20:09:35 +0000 Received: from mail-lf1-x135.google.com ([2a00:1450:4864:20::135]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.98.2) (envelope-from ) id 1w2ajL-00000000FAi-1ohM for pgsql-general@postgresql.org; Tue, 17 Mar 2026 20:09:34 +0000 Received: by mail-lf1-x135.google.com with SMTP id 2adb3069b0e04-5a1307438ddso6095905e87.1 for ; Tue, 17 Mar 2026 13:09:32 -0700 (PDT) ARC-Seal: i=1; a=rsa-sha256; t=1773778171; cv=none; d=google.com; s=arc-20240605; b=fdfdFgFMV8hrivk/ktXc0Z7qXLpLEmXUOUseoR72uVOLI+xwlODgUSZrZPdD+FIRcG G05XY01r7oFG/IUwnEA5jl0dURJYRQAMWPoFDnQf8SnZwd8APWckeEqL9++UFKXReSDZ EDxLi7XFJ/ZOqzxCVP3XjymtaxfNayxa2C/WfUzcUXjH6TjSoFttco89LFITVHaJvGTf +/WfAkhgdWABsZSa65RctEwDugpxlSfAFYit0eSUWDYfSyAFP2IfmaHg7G2VwkfcbgTv K2k11hhKaL9vpPR6ASvPMRhex6b+uu8I5tzpd3XnDCAffYNifTWQEUUiZD47t6rZxXFC HL2w== 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=imV4q50dH+fDvRBx5b2jkBVfJ5wePxhK8uRFtamlqaM=; fh=cQaUnmuwjuR9OsxDL7SxCVBwEjDYlbKL9Ym3U6WPyC4=; b=Q9UPRm4NKQfFEmjyruU+zAqveJPMg2qVlvK6lcvezUHm1wTchiuLKRDnUrJZZzQphD kXJ1rg0rXoOjwVWFn0KbI3Y/W6a0d7a7uGXZ7Hy3On0KFiHQ3vqehqUtLDFtD3DlmYZW wouJjO5+fCqe5vA2IqFjfZqPWIGfeRokD2k9xWChbm9WCWyPW6mD6f1GiNtLYjLzjoaN zlS9ZJPD9ih4t1PUyVCpYpzm59xDcaDICnmHSmPpKse8Z18wPXyp9WB5Fr0I31KnhZOM 01u0H04oGCXdZ6yu4H6HHLH/m+X8nKYXYojqBshzlWeWJ0wxYBsA68DNRQA70zcapBpX FpBA==; 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=1773778171; x=1774382971; 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=imV4q50dH+fDvRBx5b2jkBVfJ5wePxhK8uRFtamlqaM=; b=TXkK23pidcE5pOGnqzDQ97HaOrUhiOPZ3XeX4aiBjK7lmUAnjh+jXLZu76zcw8e9pN cTfSWUJ355xDA2w2XjokvPGb4A1VeZblO0sw5zQUoHmsG4WOt5whkKszvLqyPjaBmykc +Qhoe+22lsU12uc3EGXPbJITwus6TgjSC8uAyYUv4HDAqQR4WHfhtmVp8TPgBVh/Ydy3 HXXXlQCfxbS9tOW8hMEvZM1UynNBYQEH65q0ehkw4XO+rG1FojrCbussIZorB5sBuyQv 4JLNMq3PhG8xZQqZFrXr2wRadPiaWtClp+tSgEihgzR136nD4YkLBPJNfsHb17Ytb5aS 2Zzg== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20251104; t=1773778171; x=1774382971; 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=imV4q50dH+fDvRBx5b2jkBVfJ5wePxhK8uRFtamlqaM=; b=Z7OOChOv3iOODGX0Ozv8f1dWiMgF3AuS67g2Cbeq2cV5a8dSLVPkchSnzkbQrigqzI 0UXX7rHW2D0rnEzUi18NrPYA7DoAaDUab89sP0eQhaMmU1KAUJDzeHVEqPBiMc3eIFJy wJKYU97ZPVYux1SNrdmY5EcqqquCpyqkpsFQtg1SlAY9SQFFISeEdDMrPikDByYJszqy ElYNSF/Zf4lVV1r5tm26TaUxD5e6qOuzcos5k3vZH31QSb5vRLtvHTR8QGM8CYF0e1Mj GqRkd1DFZzZ2easY+y8sSTqhmrBaj7xYnWp9LwsyYrGyzDPAQHHVOjELTwVpLWdAbH6n IkHg== X-Gm-Message-State: AOJu0YwUyTVk3QiaSforWpG7lFzqsoxJ3MlyvXM8RMeIPQ2g0y8Y6t0m DbvPQ1wAzvIFGC7FgQlvCCtAKDKoVlAuUTmPb8+tFMcJmlJNcTl3vn23n0brkufCiKUFtrD8Sba DNgrlxg4fndCCzXHXmw8VU2QtThK7w+sYi15j0lBKXkzdRWGppO2l7w== X-Gm-Gg: ATEYQzwWQgFg4RNpCnE8OblI7CV57X5xgtT4lyEqH90LgNGJTWLK2URFJAu/+I8h843 FYShTy8gEzUdJpMoHaLed7mQQmWLziz5FpPA7RFo+Je4X2samVg2bXRKEMmstQRqm51joGE5Ctb RMGaRt3iG7y2R1DbF64NuO4/xhlGgycinYheIdcAjTtfFwK68mXUCuoGm48GzMYRejvCQEXPUtk msyr7u6H6Fdiz3btl6oZ7RBZgROFg6b4CmEMGKTbLrKlwlFDn7sewdvhw6MhTkj7xFMET7MvwZS 8EHTxBmCdQ== X-Received: by 2002:a05:6512:6a:b0:5a1:ea0:afa8 with SMTP id 2adb3069b0e04-5a2796c0beamr212897e87.40.1773778170876; Tue, 17 Mar 2026 13:09:30 -0700 (PDT) MIME-Version: 1.0 References: In-Reply-To: From: Marcos Pegoraro Date: Tue, 17 Mar 2026 17:08:54 -0300 X-Gm-Features: AaiRm50VWg3tInOgJOQFkdSja5LBZ37RfEezqCcjf34E1gNlHxix8XafwPT66sk Message-ID: Subject: Re: Trying to understand pg_get_expr() To: Adrian Klaver Cc: pgsql-general Content-Type: multipart/alternative; boundary="000000000000c927fd064d3de96c" List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --000000000000c927fd064d3de96c Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: quoted-printable Em ter., 17 de mar. de 2026 =C3=A0s 16:31, Adrian Klaver < adrian.klaver@aklaver.com> escreveu: > Why does the =3D 'test' not return anything? for me pg_get_expr(adbin, adrelid) returns 'test'::character varying so it differs from 'test' regards Marcos --000000000000c927fd064d3de96c Content-Type: text/html; charset="UTF-8" Content-Transfer-Encoding: quoted-printable
Em ter., 17 de mar. de 2026 =C3=A0s = 16:31, Adrian Klaver <adria= n.klaver@aklaver.com> escreveu:
W= hy does the =3D 'test' not return anything?

for me=C2=A0pg_get_expr(adbin, adrelid) returns=C2=A0= 'test'::character varying
so it differs fr= om 'test'

regard= s
Marcos
--000000000000c927fd064d3de96c--