feathers-knex icon indicating copy to clipboard operation
feathers-knex copied to clipboard

Published 20 hours ago • verified publisher icon feathersjs-ecosystem

Add array-type operators

Open michalgm opened this issue 5 years ago • 1 comments

It would be nice to have operators for postgres array-type fields: https://www.postgresql.org/docs/9.0/functions-array.html Incoming PR to add:

  • contains (@>)
  • contained_by (<@)
  • overlap (&&)

michalgm avatar Nov 11 '19 05:11 michalgm

I agree to this, this has been causing a lot of issues. I have been storing arrays into json fields, as JSON.stringify, but I cannot query these. Been trying to figure out a way around this and other than storing it as text, then managing it... I cannot seem to find an easy way.

MarcGodard avatar Jul 06 '23 23:07 MarcGodard