Some base types of MobilityDB come from PostgreSQL itself or from an extension MobilityDB requires: jsonb and jsonpath from PostgreSQL, h3index from the h3 extension, and pcpoint and pcpatch from the pointcloud extension. In PostgreSQL their operators and functions keep the names their provider gives them, and every engine, PostgreSQL included, also calls them by the names of the following table.

Their values are compared with the functions of the section called “Traditional Comparisons” and with cmp, and hashed with hash and hashExtended, which Spark and Flink call jsonbHash, jsonbHashExtended, h3indexHash and h3indexHashExtended, since these engines name the hash function of every type after the type. A value is read from its text with jsonbFromText, jsonpathFromText and h3indexFromText, and written as text with asText; in PostgreSQL a literal and a cast from or to text do the same. A pcpoint or a pcpatch is written as the hexadecimal form of its Well-Known Binary, read with pcpointFromHexWKB and pcpatchFromHexWKB and written with asHexWKB.