"Jaisingkar, Piyush" <Piyush.Jaisingkar@xxxxxxxxxxx> 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@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
