Re: [HACKERS] Json support for array pseudotypes

2017-02-21 Thread Andrew Dunstan
On 02/21/2017 06:01 PM, Tom Lane wrote: > Andrew Dunstan writes: >> The attached tiny patch lets the to_json(b) routines convert objects >> with array pseudotypes to json{b}. The main impetus for this came from >> my trying to convert the annyarray columns in

Re: [HACKERS] Json support for array pseudotypes

2017-02-21 Thread Tom Lane
Andrew Dunstan writes: > The attached tiny patch lets the to_json(b) routines convert objects > with array pseudotypes to json{b}. The main impetus for this came from > my trying to convert the annyarray columns in pg_stats to json and > finding that they ended up

[HACKERS] Json support for array pseudotypes

2017-02-21 Thread Andrew Dunstan
The attached tiny patch lets the to_json(b) routines convert objects with array pseudotypes to json{b}. The main impetus for this came from my trying to convert the annyarray columns in pg_stats to json and finding that they ended up as text instead of json arrays. This way to_json on these