Re: BUG #9519: Allows storing scalar json, but fails when querying

Alf Kristian Støyle wrote
> select data #> '{"a"}' from jtest;
> ?column?
> ----------
>
>
> "b"
> (3 rows)
>
>
> select data #> '{"a"}' from jtest where (data #> '{"a"}')::text = 'b';
> ?column?
> ----------
> (0 rows)
>
>
> Am I doing a wrong conversion here, or is something else going on? If the
> data in the database did not contain scalar values, then ->> works fine in
> WHERE. The following is almost the query we are actually trying run
> (checking for existence):

Side not - please follow the example set by others and trim your quoting and
bottom-post.

As to your comment - the example above shows that the where clause is
evaluating to:

Where '"b"' = 'b' -- which is false.

Maybe try #>> which is defined to return text instead of an object.

David J.

--
View this message in context: http://postgresql.1045698.n5.nabble.com/BUG-9519-Allows-storing-scalar-json-but-fails-when-querying-tp5795417p5795538.html
Sent from the PostgreSQL - bugs mailing list archive at Nabble.com.