feathersjs / feathers

The API and real-time application framework
https://feathersjs.com
MIT License
15.04k stars 751 forks source link

Support additional postgres operators #3377

Open michalgm opened 9 months ago

michalgm commented 9 months ago

I have a postgres database that makes use of array fields and fulltext indexes. I need to be able to perform queries on those fields using the following postgres operators:

I made a PR for the v4 feathers-knex module implementing these: https://github.com/feathersjs-ecosystem/feathers-knex/pull/236 However, it wasn't immediately clear to me how to implement this in the new knex core module.

Also, reading the migration guide, it seems like perhaps these could be defined in my service definitions using the filter/operator properties? The documentation there wasn't very clear how these are meant to function.