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!
Very cool, I look forward to using these.
ReplyDeleteWill this be available in PostgreSQL 9.4 or 9.3.x release?
ReplyDeleteWe 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:
ReplyDeletehttps://bitbucket.org/IVC-Inc/json_object
https://github.com/pgexperts/json_build
https://bitbucket.org/IVC-Inc/json_to_record
I'll try these extensions on 9.3. Thanks for your reply!
ReplyDelete