, Piyush
Cc: pgsql-general@postgresql.org
Subject: Re: [GENERAL] Passing of where clause to remote table in FDW
"Jaisingkar, Piyush" 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:
> EXPL
"Jaisingkar, Piyush" 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_BU
Hello,
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,C