JSON for PG 9.2 ... and now for 9.1!

Sunday, February 5. 2012

Robert Haas committed his bare bones JSON type five days ago, and three days later I committed my array_to_json and row_to_json constructors, so this is now definitely a go for 9.2. Kudos to Robert for persisting with this - I had just about given up on us getting it done for this release.

As an added bonus for those of you who are a bit impatient to use this stuff, I have back ported this to 9.1 as an extension. You can get the code from my bitbucket repository, and when I have polished it a bit more I will publish it on PGXN.

PLEASE NOTE: this should work fine if you dump and restore the database when moving to 9.2 - just suppress the extension creation. But it won't work with binary upgrade.

Posted by Andrew Dunstan in PostgreSQL at 20:24 | Comments (2) | Trackbacks (0)

Trackbacks

Trackback specific URI for this entry

No Trackbacks

Comments

Display comments as (Linear | Threaded)

Hello Andrew! 
 
Have you eventually released JSON for PG 9.1 on PGXN? That would be terrific! 
 
If you need a hand, just ask! Cheers, 
 
-- Daniele

#1 Daniele Varrazzo (Homepage) on 2012-07-18 20:50 (Reply)

I thought somebody else had. I'm about to do a bit of maintenance work on it, so I'll see what needs to be done.

#1.1 Andrew Dunstan on 2012-07-19 18:12 (Reply)

Add Comment

Blog Administration

Open login screen

Calendar

Quicksearch

Syndicate This Blog

Powered by

JSON for PG 9.2 ... and now for 9.1!

Andrew's PostgreSQL blog

Sunday, February 5. 2012

JSON for PG 9.2 ... and now for 9.1!

My Links etc

Blog Administration

Calendar

Quicksearch

Archives

Categories

Syndicate This Blog

Powered by