Re: [GENERAL] convert from json to text[]

2013-06-27 Thread Andreas Kretschmer
Merlin Moncure mmonc...@gmail.com wrote: json deserialization was heavily enhanced in the upcoming 9.3 release which would make dealing with this triival. for now, you have to fire up pl/v8 or another pl with heavy json support or implement a crude parser in sql :/

[GENERAL] convert from json to text[]

2013-06-26 Thread Mason Leung
Hi, I am running postgres 9.2.4 and 1 of my columns (column name is old_field) is type json. When I select from this table, I get the following sample data select old_field from table1; [], ['a', 'b'] ['a'] [] How do I change the data type from json to text[]? I have tried alter table

Re: [GENERAL] convert from json to text[]

2013-06-26 Thread Merlin Moncure
On Wed, Jun 26, 2013 at 8:34 PM, Mason Leung h2op...@gmail.com wrote: Hi, I am running postgres 9.2.4 and 1 of my columns (column name is old_field) is type json. When I select from this table, I get the following sample data select old_field from table1; [], ['a', 'b'] ['a'] [] How