pt_predecessor

Name and Parameters

pt_predecessor( PostTIME , 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 MetBy. In other words it returns true if the second geometry-posttime tuple represents an object that is a predecessor of the object represented by the first tuple.

Examples

SELECT pt_predecessor( 
'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
 t

SELECT pt_predecessor( 
'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
 f

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_successor

---

List of SQL Functions