pub const FROM_BLOCK_SPAN_WHERE_OVERLAPPING: &str = "-- consider existing block from *s to *e\n-- __ __ *s __ __ *e __ __\n--\n-- rather than look at all overlapping possibilites\n-- there are only two possibilities for !overlapping\n-- :e is strictly less than *s\n-- :s :e\n-- :s is strictly greater than *e\n-- __ __ __ __ __ __ :s :e\n--\n-- overlapping = !!overlapping\n-- => !(:e < *s || *e < :s)\n--\n-- this is true IFF the caller ensures that :s <= :e\n-- i.e. the caller MUST provide a valid span to compare for calculating overlap.\nFROM\n BlockSpan\nWHERE\n target_id = :target_id\n AND target_reason = :target_reason\n AND NOT(\n :end_us < start_us\n OR end_us < :start_us\n )\n";