Postgresql Arrays

rubyonrails-talk
#1

Hi,

I was wondering if anyone knows how ActiveRecord deals with Postgresql arrays? Specifically I am trying to figure out how to: a) Setup migration that creates the following table:

CREATE TABLE sal_emp ( name text, pay_by_quarter integer );

b) insert records into this table through activerecord like SalEmp.create({:name => “Tom”, :pay_by_quarter => [1,2,3]}) Is this even possible?

Thanks,

Ram

#2

Hi,

I was wondering if anyone knows how ActiveRecord deals with Postgresql arrays? Specifically I am trying to figure out how to: a) Setup migration that creates the following table:

CREATE TABLE sal_emp (    name text,    pay_by_quarter integer );

b) insert records into this table through activerecord like SalEmp.create({:name => "Tom", :pay_by_quarter => [1,2,3]}) Is this even possible?