5 ms·
The article didn't answer the question for me of how to query for the absence of a property, without getting an entire document collection first. I was really
by sonjaqql 5y ago
The article didn't answer the question for me of how to query for the absence of a property, without getting an entire document collection first.
I was really hoping there was a secret to search against null or undefined.
Is there a NoSQL solution that does allow for such queries?
- lokedhs 5y agoWith CouchDB you can do it. You create a view filters on the absence or prescense of that field. I'm not sure if that answers your question, as I don't know how other nosql databases handle indexing.
- sonjaqql 5y agoI'll investigate the constraints of CouchDB, thanks!
- sourcesmith 5y agoIf you want to include Postgres jsonb columns in that then a partial index of the expression of a NOT of the jsonb contains jsonb operator.