scottymac · August 29, 2015 14:04
diff --git a/Postgres Cast an Array Column for Comparison b/Postgres Cast an Array Column for Comparison
 -- datetimes is an array column of strings (b/c ActiveRecord doesn't support arrays of datetimes just yet (but soon))
 -- This is doing a date comparison

 SELECT * FROM  table WHERE now() ANY (CAST(datetimes as timestamp[]))

 in ActiveRecord:
 scope :past, lambda {
  where(":now > ALL (CAST(datetimes as timestamp[]))", { now: Time.zone.now })
 }
	-- datetimes is an array column of strings (b/c ActiveRecord doesn't support arrays of datetimes just yet (but soon))
	-- This is doing a date comparison

	SELECT * FROM table WHERE now() ANY (CAST(datetimes as timestamp[]))

	in ActiveRecord:
	scope :past, lambda {
	where(":now > ALL (CAST(datetimes as timestamp[]))", { now: Time.zone.now })
	}