ActiveRecord: How to find Postgres rows with empty array?

Question

I have a model created with this migration:

create table :some_table do |t|
  t.string :list, array: true, default: []
end

I would like to find the record whose "list" array is empty. I tried with this:

SomeTable.where(list: [])

but it returns nil and I have records with the list emtpy.

may you like to study more about it dockyard.com/blog/ruby/2012/09/18/… — Pardeep Dhingra
– Pardeep Dhingra, Commented Dec 4, 2015 at 12:51
Can you put this through an answer? I will give you karma then. Ah, and it's where(list: '{}') — Fran Martinez
– Fran Martinez, Commented Dec 4, 2015 at 13:13

Pardeep Dhingra · Accepted Answer · 2015-12-04 13:16:00Z

1

Try:

SomeTable.where(list: '{}')

answered Dec 4, 2015 at 13:16

Pardeep Dhingra

3,9467 gold badges35 silver badges57 bronze badges

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

1 Answer 1