Tuesday, January 28, 2014

New Json functions

I've been pretty busy, and neglected this blog for a while, but I'm very happy that today I have been able to commit a parcel of new JSON functions that will be in the next PostgreSQL release. These include functions to create very complex JSON tree structures, and a function to aggregate pairs of values as JSON objects.

You can see some documentation in the development version Documents.

Thanks to Marko Tiikkaja for his timely review.

Stay tuned, there's more JSON goodness coming!

4 comments:

  1. Very cool, I look forward to using these.

    ReplyDelete
  2. Will this be available in PostgreSQL 9.4 or 9.3.x release?

    ReplyDelete
  3. We don't backpatch features - that's one of the main things that helps keep PostgreSQL super stable. So they will be in 9.4. For 9.3 they are available as extensions, albeit with a few differences, but with the main functionality:

    https://bitbucket.org/IVC-Inc/json_object
    https://github.com/pgexperts/json_build
    https://bitbucket.org/IVC-Inc/json_to_record

    ReplyDelete
  4. I'll try these extensions on 9.3. Thanks for your reply!

    ReplyDelete