loopback-connector-postgresql icon indicating copy to clipboard operation
loopback-connector-postgresql copied to clipboard

feat(operators): Adding 'overlaps' operator support

Open arnaud16571542 opened this issue 2 years ago • 1 comments

This PR add support to the 'overlaps' postgresql extended operator. Currently the 'contains' operator return rows which contains all items in submitted array. The new 'overlaps' operator return rows which contains any items in submitted array.

The 'overlaps' operator use the && postgresql array operator, and is described by the postgresql doc as "Do the arrays overlap, that is, have any elements in common?" https://www.postgresql.org/docs/current/functions-array.html

Code is updated.
Documentation is updated.
Tests are updated & OK.

Checklist

  • [X] DCO (Developer Certificate of Origin) signed in all commits
  • [X] npm test passes on your machine
  • [X] New tests added or existing tests modified to cover all changes
  • [X] Code conforms with the style guide
  • [X] Commit messages are following our guidelines

arnaud16571542 avatar May 31 '22 11:05 arnaud16571542

Thanks for the PR. In the future, consider updating the existing PR instead of opening new ones so that it's easier for the maintainers to follow and track. Thanks!

achrinza avatar May 31 '22 22:05 achrinza

@arnaud16571542 are you still working on this PR ? If not, can we create a new PR with all the fixes and changes ? This is an important feature for the community.

samarpanB avatar Nov 16 '22 14:11 samarpanB