Re: [PATCH] Add support function for containment operators - Mailing list pgsql-hackers

From Tom Lane
Subject Re: [PATCH] Add support function for containment operators
Date
Msg-id 3099039.1705777302@sss.pgh.pa.us
Whole thread Raw
In response to Re: [PATCH] Add support function for containment operators  (jian he <jian.universality@gmail.com>)
Responses Re: [PATCH] Add support function for containment operators
List pgsql-hackers
jian he <jian.universality@gmail.com> writes:
> Now I see your point. If the transformed plan is right, the whole
> added code should be fine.
> but keeping the textrange_supp related test should be a good idea.
> since we don't have SUBTYPE_OPCLASS related sql tests.

Yeah, it's a little harder to make a table-less test for that case.
I thought about using current_user or the like as a stable comparison
value, but that introduces some doubt about what the collation would
be.  That test seems cheap enough as-is, since it's handling only a
tiny amount of data.

Committed.

            regards, tom lane



pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: PG12 change to DO UPDATE SET column references
Next
From: Pavel Stehule
Date:
Subject: Re: Schema variables - new implementation for Postgres 15