Re: examine_variable ignored CollateExpr

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: ZizhuanLiu X-MAN <44973863(at)qq(dot)com>
Cc: jian he <jian(dot)universality(at)gmail(dot)com>, PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: examine_variable ignored CollateExpr
Date: 2026-08-16 15:59:31
Message-ID: 453227.1786895971@sss.pgh.pa.us
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

"=?utf-8?B?Wml6aHVhbkxpdSBYLU1BTg==?=" <44973863(at)qq(dot)com> writes:
> My current proposal is along the following lines:

> * eval_const_expressions() should already have stripped adjacent
> * RelabelTypes. However, stripping PlaceHolderVars above may have
> * brought previously separated RelabelTypes into adjacency, whether
> * at the top level or within a deeper subtree. Therefore, run
> * eval_const_expressions() again to normalize the expression.

That is a ridiculously expensive way to fix this problem.

regards, tom lane

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Álvaro Herrera 2026-08-16 16:21:33 Re: pgcrypto.sgml: built in -> built-in
Previous Message ZizhuanLiu X-MAN 2026-08-16 15:42:15 Re: examine_variable ignored CollateExpr