Horton
Menu

Re: Trying to understand pg_get_expr()

Marcos Pegoraro <marcos@f10.com.br>

View thread
From: Marcos Pegoraro <marcos@f10.com.br>
To: Adrian Klaver <adrian.klaver@aklaver.com>
Cc: pgsql-general <pgsql-general@postgresql.org>
Date: 2026-03-17T20:26:52Z
Lists: pgsql-general 
Em ter., 17 de mar. de 2026 às 17:19, Adrian Klaver <
adrian.klaver@aklaver.com> 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