Re: Passing of where clause to remote table in FDW

"Jaisingkar, Piyush" <Piyush.Jaisingkar@nttdata.com> writes:
> While using fdw I am trying to get and filtered data from a foreign table. Filtering using a regex in where clause as
follows:

> EXPLAIN ANALYZE VERBOSE SELECT CAF1.uprn
>       FROM XYZ as CAF1
>       WHERE
>
(regexp_replace(upper(concat(CAF1.SUB_BUILDING_NAME,CAF1.BUILDING_NAME,CAF1.BUILDING_NUMBER,CAF1.STREET_DESCRIPTION,
CAF1.TOWN_NAME)),'[^a-zA-Z0-9]','') = '84WELLINGTONROADEXETER'); 

concat() is not immutable (it's only stable) so it can't be sent for
remote execution.  Use the || operator instead.

            regards, tom lane