mongo_fdw
mongo_fdw copied to clipboard
EnterpriseDB
PostgreSQL foreign data wrapper for MongoDB
This PR adds support to run `LIKE` (i.e. `~~`) or `ILIKE` (i.e. `~~*`) on the remote server using the `regexMatch` operator from Mongo.
Add separate `INSTALL.md`. Other changes in `README.md` for unifying with https://github.com/pgspider FDW documentation template and by https://github.com/ibarwick/firebird_fdw/blob/master/README.md example of advanced FDW documentation.
Update autogen.sh to warn about the change in usage and the unsupported Legacy driver instead of killing the script. A less radical approach when --with-master option is used. This would...
Closed issue #163 implies we cannot get WHERE clause pushdown on ObjectID (NAME) types queries. For example, in the provided example in https://www.enterprisedb.com/docs/mongo_data_adapter/latest/08c_example_where_pushdown/ querying for a specific one causes a...
Hi, It would be great to add support to run `LIKE` and `ILIKE` operators on the remote server using `regexMatch`. I am proposing this [PR](https://github.com/EnterpriseDB/mongo_fdw/pull/176) implementing this feature.
When trying to use [Azure's free tier of Cosmos DB for MongoDB (vCore)](https://learn.microsoft.com/en-us/azure/cosmos-db/mongodb/vcore/free-tier) with MongoDB 6.0 API on PG 16 I ran into the following: ``` # CREATE EXTENSION mongo_fdw;...
Hello, When default options are used LEFT JOIN returns no results. If the enable_join_pushdown is set to false, query works as expected. Tried on 5.1.1
Make provision for C_COLLATION_OID and POSIX_COLLATION_OID, which are also built-in types. I'm not 100% sure what the impact will be, but everywhere specifically DEFAULT_COLLATION_OID was used, the other two are...
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...