"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
