News for hackers. Stuff that matters.
Re:PostgreSQL 9.4 Released by ak4g on Thursday December 18, 2014 @08:16PM (#8770691)
the json type just stores the string value passed to it, but only the final value is available to the JSON-aware operators.

  mydb=# select
      ('{"foo": 1, "foo": 2}'::jsonb)->'foo' jsonb_foo,
      ('{"foo": 1, "foo": 2}'::json)->'foo'  json_foo;
  jsonb_foo|2
  json_foo|2

There are no comments on this comment yet.