3 ms·
Hstore's query is only string matching, you cannot do the rich querying which mongodb allows.
by amalag 14y ago
Hstore's query is only string matching, you cannot do the rich querying which mongodb allows.
- masklinn 14y agoNot sure what you're trying to say, but hstore's querying most definitely isn't "only string matching" no. hstore values, written in queries, use string-serialization for embedding in SQL. Which is very different. And this serialization is only needed when adding content to an hstore or performing set-operations on hstores, you can perform queries on hstore fields pretty much directly via the `->` operator: SELECT id FROM Table WHERE (hs->'size')::INT >= 42 AND (hs->'name') IS NOT NULL