public inbox for [email protected]
help / color / mirror / Atom feedFrom: Marcos Pegoraro <[email protected]>
To: Adrian Klaver <[email protected]>
Cc: pgsql-general <[email protected]>
Subject: Re: Trying to understand pg_get_expr()
Date: Tue, 17 Mar 2026 17:26:52 -0300
Message-ID: <CAB-JLwbwKi6q_fG7ByGRJe-L+m9Nx+WHiTP0qhEw7qKzv37QQA@mail.gmail.com> (raw)
In-Reply-To: <[email protected]>
References: <[email protected]>
<CAB-JLwZdyUfnC047MzV9woskWH2dToNJEudR34AD8WprEn8Cig@mail.gmail.com>
<[email protected]>
Em ter., 17 de mar. de 2026 às 17:19, Adrian Klaver <
[email protected]> escreveu:
> I also tried other combinations of casting both sides of "=" and it
> still did not work.
>
"'test'::character varying" is the result of that function, not type of test
This should work
AND pg_get_expr(adbin, adrelid) = $$'test'::character varying$$;
regards
Marcos
reply
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: [email protected]
Cc: [email protected], [email protected]
Subject: Re: Trying to understand pg_get_expr()
In-Reply-To: <CAB-JLwbwKi6q_fG7ByGRJe-L+m9Nx+WHiTP0qhEw7qKzv37QQA@mail.gmail.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox