Downloads
Home   >   mailing lists

Re: get_rule_expr RelabelType node does not print COLLATE clause - Mailing list pgsql-hackers

From Tom Lane
Subject Re: get_rule_expr RelabelType node does not print COLLATE clause
Date
Msg-id 2310683.1752939960@sss.pgh.pa.us
Whole thread Raw
In response to get_rule_expr RelabelType node does not print COLLATE clause  (jian he <jian.universality@gmail.com>)
List pgsql-hackers
Tree view 
jian he <jian.universality@gmail.com> writes:
> I found in some cases, we need to print COLLATE clauses for RelabelType Node.

I have a hard time getting excited about that.  RelabelType
can only appear in plan trees, not in stored query trees,
so we do not have a requirement for 100% accuracy for dump/reload
purposes.  I'm afraid that adding COLLATE would add more chatter
than value to EXPLAIN output.

            regards, tom lane

pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: Upgrade from Fedora 40 to Fedora 42, or from PostgreSQL 16.3 to PostgreSQL 16.9
Next
From: Tom Lane
Date:
Subject: Re: MergeJoin beats HashJoin in the case of multiple hash clauses