convert from json to text[]

From: Mason Leung <h2opbun(at)gmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: convert from json to text[]
Date: 2013-06-27 01:34:30
Message-ID: CALQs-jJ0sB8SsHtKv17tiwAxzTuYZPET=5Ns=msGCpN9UZzK0w@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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 add column new_field text[] default '{}'::text[]"
UPDATE table1 SET new_field = {old_field} where old_field is not null"

Questions:
1) how to I change the data type from json to text[]
2) how to I select rows that has data and not [],

thanks
-m

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Merlin Moncure 2013-06-27 02:13:47 Re: convert from json to text[]
Previous Message Jake Silverman 2013-06-27 01:10:32 Re: Need help compiling from souce