On 3/10/2014 1:39 PM, Alf Kristian Støyle wrote:
> 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.
the json ->> 'fieldname' operator has no meaning when applied to a
scalar value. what would you suggest it should do? return a NULL ?
--
john r pierce 37N 122W
somewhere on the middle of the left coast