Ruby Sequel: Array returned by query is being returned as a String object, not an Array object

Question

I'm using the pg_array extension of Ruby Sequel.

When I select a column that is a Postgresql array, the result is a string in Ruby. How do I get this to be a Ruby array so I can use things like .each on it?

CaseTypeCategory.first(category_name: 'Subscription')[:values]
=> "{value_one,value_two}"

CaseTypeCategory.first(category_name: 'Subscription')[:values][0]
=> "{"

Our database config includes:

Sequel.extension :pg_array, :pg_inet, :pg_json

And the migration to add the columns included this:

alter_table :case_type_categories do
  add_column :values, "text[]"
end

I can write raw SQL to access single elements in the array:

select values[1] from case_type_categories where category_name = 'Subscription'

Please edit your question to include the code where you configure Sequel to use the pg_array extension for this column. — Jordan Running
– Jordan Running, Commented Jul 14, 2017 at 19:23

Jeremy Evans · Accepted Answer · 2017-07-17 14:26:04Z

4

You need to use DB.extension :pg_array, :pg_inet, :pg_json, not Sequel.extension :pg_array, :pg_inet, :pg_json. Otherwise you are just requiring the files without modifying the configuration for the Sequel::Database instance.

answered Jul 17, 2017 at 14:26

Jeremy Evans

12.2k31 silver badges27 bronze badges

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

1 Comment

Steve Wetzel Over a year ago

Awesome, thank you. Just to confirm: DB = Sequel::Model.db right?

Collectives™ on Stack Overflow

Ruby Sequel: Array returned by query is being returned as a String object, not an Array object

1 Answer 1

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related