pt_overlaps

Name and Parameters

pt_overlaps( PostTIME , PostTIME ) : boolean

Description

Checks out if two objects share at least one simultaneous period in time.

Examples

SELECT pt_overlaps('2013-2-12/2013-2-28','2013-2-12T8');
-- result
f

SELECT pt_overlaps('2013-2-12/2013-2-28','2013-2-12T8/2013-2-12T9');
-- result
t

Processable Objects

| CAL | TCS | ORD ---|---|---|--- TM_Instant | ✔ | ✔ | ✗ TM_Period | ✔ | ✔ | ✗ MultiInstant | ✔ | ✔ | ✗ MultiPeriod | ✔ | ✔ | ✗ RegularMultiInstant | ✔ | ✔ | - RegularMultiPerid | ✔ | ✔ | - ✔ : Processable

✗ : Call will cause an error

∼ : Callable without error, but returns only a pseudo result

Related functions

pt_simultaneous

pt_simultaneous_excluded_end_instants

---

List of SQL Functions