Re: Trying to understand pg_get_expr()

From: Marcos Pegoraro <marcos(at)f10(dot)com(dot)br>
To: Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com>
Cc: pgsql-general <pgsql-general(at)postgresql(dot)org>
Subject: Re: Trying to understand pg_get_expr()
Date: 2026-03-17 20:26:52
Message-ID: CAB-JLwbwKi6q_fG7ByGRJe-L+m9Nx+WHiTP0qhEw7qKzv37QQA@mail.gmail.com
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-general

Em ter., 17 de mar. de 2026 às 17:19, Adrian Klaver <
adrian(dot)klaver(at)aklaver(dot)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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Adrian Klaver 2026-03-17 20:36:34 Re: Trying to understand pg_get_expr()
Previous Message Adrian Klaver 2026-03-17 20:19:49 Re: Trying to understand pg_get_expr()