top | item 28769297

(no title)

sonjaqql | 4 years 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?

discuss

order

lokedhs|4 years ago

With 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|4 years ago

I'll investigate the constraints of CouchDB, thanks!

sourcesmith|4 years ago

If 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.