Re: Schema-qualify the equality operator when deparsing NULLIF/IS DISTINCT FROM - Mailing list pgsql-hackers

From Tom Lane
Subject Re: Schema-qualify the equality operator when deparsing NULLIF/IS DISTINCT FROM
Date
Msg-id 1842034.1783434444@sss.pgh.pa.us
Whole thread
In response to Re: Schema-qualify the equality operator when deparsing NULLIF/IS DISTINCT FROM  (michal.dtz@gmail.com)
List pgsql-hackers
michal.dtz@gmail.com writes:
> Attached is v2, which takes the opposite approach: instead of teaching
> the deparser to avoid the constructs, it gives every construct that
> resolves an operator by unqualified name a place to write a
> schema-qualified one.  That covers the full list you cataloged back in
> 2018 (10492.1531515255@sss.pgh.pa.us) -- IS [NOT] DISTINCT FROM,
> NULLIF, simple CASE, row comparisons, ANY/ALL subquery comparisons --
> plus JOIN USING / NATURAL JOIN, which has the same disease.

I didn't read the patch yet, but this sounds promising.

> If the direction looks right I will register this in the next
> commitfest (PG 20-1).

Next one is already 20-2, but please do register it.

            regards, tom lane



pgsql-hackers by date:

Previous
From: Chao Li
Date:
Subject: Re: postgres_fdw: fix cumulative stats after imported foreign-table stats
Next
From: Alexander Korotkov
Date:
Subject: Re: wait_event_type for WAIT FOR LSN