pt_successor

Name and Parameters

pt_successor( geometry, PostTIME, geometry, PostTIME ) : boolean

Description

This function returns true if the two geometries' interior intersects and the relative position from the first PostTIME argument to the second is Meets. In other words it returns true if the second geometry-posttime tuple represents an object that is a successor of the object represented by the first tuple.

Examples

SELECT pt_successor( 
'POLYGON((1 1,1 4,4 4,4 1,1 1))',
'2013',
'POLYGON((1 1,1 2,2 2,2 1,1 1))',
'2012');
-- result
 f

SELECT pt_successor( 
'POLYGON((1 1,1 4,4 4,4 1,1 1))',
'2012',
'POLYGON((1 1,1 2,2 2,2 1,1 1))',
'2013');
-- 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_predecessor

---

List of SQL Functions