staticbackendhq / core

Backend server API handling user mgmt, database, storage and real-time component
https://staticbackend.com
MIT License
682 stars 67 forks source link

Implement the in and !in query operators for PostgreSQL #41

Closed dstpierre closed 1 year ago

dstpierre commented 1 year ago

The query operators in and !in which are suppose to look for presence or absence of an item in a list isn't implemented yet in the PostgreSQL database package.

In database/postgresql/query.go line:37, an implementation is required for these query operators to work.

As reference to find the way to implement for PostgreSQL's JSONB format: https://www.postgresql.org/docs/9.5/functions-json.html

This change once implemented can be tested via a test in the database/postgresql package using the QueryDocuments function for instance.