Skip to content
ptrb edited this page May 29, 2013 · 1 revision

Name and Parameters

pt_simultaneous( PostTIME , PostTIME ) : boolean

Description

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

Examples

SELECT pt_simultaneous('2013-5-4T8:2','R10/2013-5-3/PT8H/PT16H');
-- result
f

SELECT pt_simultaneous('2013-5-4T8','R10/2013-5-3/PT8H/PT16H');
-- 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_excluded_end_instants

pt_overlaps


List of SQL Functions