"Jaisingkar, Piyush" <piyush.jaising...@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
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
