mongo_fdw icon indicating copy to clipboard operation
mongo_fdw copied to clipboard

No WHERE push down support for = ANY and <> ALL

Open Climax777 opened this issue 7 months ago • 0 comments

Currently, there is no support for pushdown on WHERE clauses like = ANY or <> ALL, where Mongo's $in: [...] or $not: {$in: [...]} would work.

Although this is probably not the most crucial of features, I need it a lot for my use case, especially with arrays of ObjectIDs. This also needs #169, which is potentially fixed by #170 according to my specific testing.

A PR will follow shortly to address the array feature.

Climax777 avatar Nov 15 '23 10:11 Climax777