If the JSON datatype accepts JSON values (not just objects), which I supposed is a valid approach, then shouldn't the JSON query operators be able to deal with that?
This is the "unfortunate" part: select data->>'foo' from jtest; => ERROR: cannot extract element from a scalar
So either, only accept JSON object (not simple JSON values), or make the JSON query operators work with JSON values as well.
Having to add an extra check constraint here is not obvious, imho.
For the record, we are working around this problem, through a small hack. Some other system is storing this kind of data in our database. We have reported a bug with them to fix it.
This is not a big problem for us, but we love Postgres, so we thought we should report this.
Cheers, Alf
On 10 March 2014 20:52, Marko Tiikkaja <marko@joh.to> wrote: