ruby-on-rails - 如何在 Active Record POSTGRES 中使用 BETWEEN 搜索字符串数组，

Question

Subscriptions
    canceled_at: ["2017-04-07T09:52:17-05:00", "2017-04-01T09:52:17-05:00"]

Canceled_at 是一个字符串数组。每个元素都是转换为字符串的 DateTime。

上面是我的订阅表。我正在尝试查询并查找给定周内具有 cancelled_at 日期的记录。

date = Date.today

Subscription.where("ANY subscriptions.canceled_at 
    BETWEEN '#{date.beginning_of_week(:sunday)}' 
    AND '#{date.end_of_week(:sunday)}'"

ruby 2.3.1p112

Answer 1

Subscription.where(canceled_at:(date.beginning_of_week(:sunday)..date.end_of_week(:sunday)))

编辑:缺少右括号