Skip to content
ptrb edited this page Jun 9, 2013 · 1 revision

Name and Parameters

pt_type( PostTIME ) : integer

Description

This function serves to query an instance's type. Result is an integer according to the following enumeration:

Type Return
TM_Instant 1
TM_Period 2
MultiInstant 3
MultiPeriod 4
MultiRegularInstant 5
MultiRegularPeriod 6

Examples

SELECT pt_type('2013-12-24T12');
-- result
1

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


List of SQL Functions