Merlin Moncure 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 :/
http://www.pgxn.org/dist/json_enhanc
On Wed, Jun 26, 2013 at 8:34 PM, Mason Leung 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 do
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 table1
