Initialize model with integer array in Postgres

Question

I'm using postgres 9.6.1, Rails 4.2.0, and the following migration:

class CreateStageBatches < ActiveRecord::Migration
  def change
    create_table :stage_batches do |t|
      t.text :item_ids, array: true, default: []
    end
  end
end

How do I create an array of integers? I've tried:

[9] pry(main)> StageBatch.new item_ids: [1,2,3]
=> #<StageBatch id: nil, item_ids: ["1", "2", "3"]>

But they are strings.

Looking at the postgres docs it looks like this is possible but I'm not sure what the syntax is for my migration or instantiation.

Joel Blum · Accepted Answer · 2017-02-05 08:47:23Z

2

try this

 t.integer 'item_ids', array: true

edited Feb 5, 2017 at 8:47

answered Feb 5, 2017 at 8:41

Joel Blum

7,89811 gold badges44 silver badges63 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Initialize model with integer array in Postgres

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related