-
Notifications
You must be signed in to change notification settings - Fork 1
pt_refsys_instance
ptrb edited this page Jun 9, 2013
·
2 revisions
pt_refsys_instance( PostTIME ) : integer
Get the instance number of an instance's reference system as integer.
SELECT pt_refsys_instance('CAL0012013-12-24T12');
-- result
1
SELECT pt_refsys_instance('CAL0022013-12-24T12');
-- result
2
SELECT pt_refsys_instance('ORD001Triassic');
-- result
1
| 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