Temporal JSONB values must satisfy the constraints specified in the section called “Validity of Temporal Types” so that they are well defined. An error is raised whenever one of these constraints are not satisfied. Examples of incorrect values are as follows.
-- Null values are not allowed SELECT tjsonb 'NULL@2001-01-01 08:05:00'; SELECT tjsonb 'Point(0 0)@NULL'; -- Base type is not a JSONB SELECT tjsonb 'Point(0 0)@2001-01-01 08:05:00';
We give next the functions and operators for temporal JSONB. Most functions and operators for temporal types described in the previous chapters can be applied for temporal JSONB types. Therefore, in the signatures of the functions given previously, the notation base represents a jsonb value and the notation ttype, represents a tjsonb value. To avoid redundancy, we only present next some examples of these functions and operators for temporal JSONB values.