Ruby where array is not empty?

Question

this_id is a string, that is an array, the_other is a boolean (from before I learned to default: false).

I do not know the format a search where the arrays('that') are not empty, [], i.e., have at least one thing in it. Thanks!

This.where("this_id = ? and that = ? and the_other IS NOT NULL", "#{@this.id}", ...NOT_EMPTY?)

Abdul Rehman · Accepted Answer · 2020-03-29 14:04:40Z

2

According to the PostgreSQL array documentation here, To compare with array type column you can use '{}', so you can write your query like this

This.where("this_id = ? and that != '{}' and the_other IS NOT NULL", "#{@this.id}")

This should return the required rows.

answered Mar 29, 2020 at 13:59

Abdul Rehman

7427 silver badges14 bronze badges

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

3 Comments

Ok thanks! ... so ruby array [ ] and postres array { }. whats a postgres hash, [ ] ?

there is no hash type in postgresSQL, but there is a json type or hstore. here are documentation links for both. postgresqltutorial.com/postgresql-json postgresqltutorial.com/postgresql-hstore

my pleasure. :)