Many thanks for the fast response.
Using an SRF is an interesting idea, I'll have a play and see if we can
make that work.
Cheers,
Kai
On Wed, Jan 27, 2021 at 3:27 PM Tom Lane wrote:
> Kai Daguerre writes:
> > We often have virtual tables where a list operation is not
>
rn a
path which returns a single row when the 'key' column is used. This does
provide a qual, however it is of type T_Var - I believe I need a constant
qual.
Any suggestion welcome as to either a different way to structure the query
or whether the FDW can request/enforce the orderin