Home > mailing lists

Re: Trying to understand pg_get_expr() - Mailing list pgsql-general

From	Marcos Pegoraro
Subject	Re: Trying to understand pg_get_expr()
Date	March 17 23:26:52
Msg-id	CAB-JLwbwKi6q_fG7ByGRJe-L+m9Nx+WHiTP0qhEw7qKzv37QQA@mail.gmail.com Whole thread
In response to	Re: Trying to understand pg_get_expr() (Adrian Klaver <adrian.klaver@aklaver.com>)
Responses	Re: Trying to understand pg_get_expr()
List	pgsql-general

Tree view

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

pgsql-general by date:

From: Adrian Klaver
Date: 17 March, 23:19:49
Subject: Re: Trying to understand pg_get_expr()

From: Adrian Klaver
Date: 17 March, 23:36:34
Subject: Re: Trying to understand pg_get_expr()

Re: Trying to understand pg_get_expr() - Mailing list pgsql-general

Previous

Next