Go back PostgreSQL

item in Postgres Array fiield using Rais AREL 



Customer.tags  is Array Postgres field
# t.text "tags", default: [], array: true

Customer
  .where(website: "blabla.com")
  .where.not(tags: [])
SELECT "customers".* FROM "customers" WHERE "customers"."website" = 'blabla.com' AND "customers"."tags" != '{}'

Customer
  .where(website: "blabla.com")
  .where(tags: [])
SELECT "customers".* FROM "customers" WHERE "customers"."website" = 'blabla.com' AND "customers"."tags" = '{}'


Customer
  .where(website: "blabla.com")
  .where(tags: ["bar"])
SELECT "customers".* FROM "customers" WHERE "customers"."website" = 'blabla.com' AND "customers"."tags" = '{bar}'