Displaying 1 result from an estimated 1 matches for "my_id_field".
2013 Jun 26
0
json text to text array migration questions
Hi,
I have field in postgres (9.2.4) with type json. The field looks like
Column | Type | Modifiers | Storage |
Stats target | Description
---------------------+-----------------------------+-----------+----------+--------------+-------------
my_id_field | json | | extended
| |
When I do " select my_id_field::json from table1", it returns something like
[]
[]
[]
["abc"]
[]
[]
[]
I like to change this from type json to text[] and included the following
in the mi...