Knowledge base for teams
How to detect time-overlapping-records in Postgres + RailsPublic16 Jan 12:06
Model
.where("TSRANGE(?, ?, '()') && TSRANGE(starts_at, ends_at, '()')", starts_at, ends_at)
.where.not(id: record_id)
.exists?
Both starts_at and ends_at columns should be indexed.
@ownadiSimilar entries
None
Other by @ownadi
Comments
Empty! You must sign in to add comments.