pt_refsys_type

Name and Parameters

pt_refsys_type( PostTIME ) : integer

Description

Get the type of an instance's reference system. Result is an integer according to the following enumeration:

Type	Return
CAL	1
TCS	2
ORD	3

Examples

SELECT pt_refsys_type('CAL0012013-12-24T12');
-- result
1

SELECT pt_refsys_type('CAL0022013-12-24T12');
-- result
1

SELECT pt_refsys_type('ORD001Triassic');
-- result
3

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_type, pt_refsys_instance

---

List of SQL Functions