-
-
Notifications
You must be signed in to change notification settings - Fork 792
Closed
Description
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:
- && - array overlap - https://www.postgresql.org/docs/current/functions-array.html#ARRAY-OPERATORS-TABLE
- @> - array contains - https://www.postgresql.org/docs/current/functions-array.html#ARRAY-OPERATORS-TABLE
- <@ - array contained by - https://www.postgresql.org/docs/current/functions-array.html#ARRAY-OPERATORS-TABLE
- @@ - fulltext match - https://www.postgresql.org/docs/current/functions-textsearch.html
I made a PR for the v4 feathers-knex module implementing these: feathersjs-ecosystem/feathers-knex#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.
Metadata
Metadata
Assignees
Labels
No labels