docs/migrations.md in postgres_ext-0.2.2 vs docs/migrations.md in postgres_ext-0.3.0
- old
+ new
@@ -72,5 +72,21 @@
# smallint[]
t.string :macaddr_column_1, :array => true, :limit => 30
# char varying(30)[]
end
```
+
+### Converting to Arrays
+
+If you have an existing column with a string-delimited array (e.g. 'val1 val2 val3') convert that data using SQL in your migration.
+
+```ruby
+class AddLinkedArticleIdsToLinkSet < ActiveRecord::Migration
+ def change
+ add_column :link_sets, :linked_article_ids, :integer, :array => true, :default => []
+ execute <<-eos
+ UPDATE link_sets
+ SET linked_article_ids = cast (string_to_array(linked_articles_string, ' ') as integer[])
+ eos
+ end
+end
+````