Re: Custom FDW - the results of a nested query/join not being passed as qual to the outer query

2021-01-28 Thread Kai Daguerre
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 >

Custom FDW - the results of a nested query/join not being passed as qual to the outer query

2021-01-27 Thread Kai Daguerre
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