2 forum posts by user EternityForest
Reply: Document or specify what json_extract does with nonexistant keys?
(artifact: d23ebcd6b1 user: EternityForest)
Ah, I missed that line in the docs! Thank you for pointing that out!
Should I assume, that since it is documented as such, I can continue relying on it to return NULL instead of an error, as a way to test for existence?
Post: Document or specify what json_extract does with nonexistant keys?
(artifact: 25c857652d user: EternityForest)
Hello All! Right now, json_extract says:
But if I try to access a nonexistant key, I get null, not an error. This seems to be what other DBs do, and is very convenient in my particular case, but nonetheless it is still undefined behavior.
Is the current behavior "How things should be"? If so, should the documentation change to reflect that? It's a bit of a "hidden feature" now.