{"kind": "type", "major": "18", "total": 121, "rows": [{"slug": "bit", "name": "bit", "category": "Bit strings", "summary": "fixed-length bit string", "aliases": [], "url": "/wiki/type/bit/?v=18", "present_in": ["10", "11", "12", "13", "14", "15", "16", "17", "18", "19", "20"]}, {"slug": "varbit", "name": "bit varying", "category": "Bit strings", "summary": "variable-length bit string", "aliases": ["varbit", "varbit [ ( n ) ]"], "url": "/wiki/type/varbit/?v=18", "present_in": ["10", "11", "12", "13", "14", "15", "16", "17", "18", "19", "20"]}, {"slug": "bool", "name": "boolean", "category": "Boolean", "summary": "logical Boolean (true/false)", "aliases": ["bool"], "url": "/wiki/type/bool/?v=18", "present_in": ["10", "11", "12", "13", "14", "15", "16", "17", "18", "19", "20"]}, {"slug": "char", "name": "\"char\"", "category": "Character strings", "summary": "single-byte internal type", "aliases": [], "url": "/wiki/type/char/?v=18", "present_in": ["10", "11", "12", "13", "14", "15", "16", "17", "18", "19", "20"]}, {"slug": "bpchar", "name": "character", "category": "Character strings", "summary": "fixed-length character string", "aliases": ["bpchar", "char [ ( n ) ]"], "url": "/wiki/type/bpchar/?v=18", "present_in": ["10", "11", "12", "13", "14", "15", "16", "17", "18", "19", "20"]}, {"slug": "varchar", "name": "character varying", "category": "Character strings", "summary": "variable-length character string", "aliases": ["varchar", "varchar [ ( n ) ]"], "url": "/wiki/type/varchar/?v=18", "present_in": ["10", "11", "12", "13", "14", "15", "16", "17", "18", "19", "20"]}, {"slug": "name", "name": "name", "category": "Character strings", "summary": "internal type for object names", "aliases": [], "url": "/wiki/type/name/?v=18", "present_in": ["10", "11", "12", "13", "14", "15", "16", "17", "18", "19", "20"]}, {"slug": "pg_brin_bloom_summary", "name": "pg_brin_bloom_summary", "category": "Character strings", "summary": "pseudo-type representing BRIN bloom summary", "aliases": [], "url": "/wiki/type/pg_brin_bloom_summary/?v=18", "present_in": ["14", "15", "16", "17", "18", "19", "20"]}, {"slug": "pg_brin_minmax_multi_summary", "name": "pg_brin_minmax_multi_summary", "category": "Character strings", "summary": "pseudo-type representing BRIN minmax-multi summary", "aliases": [], "url": "/wiki/type/pg_brin_minmax_multi_summary/?v=18", "present_in": ["14", "15", "16", "17", "18", "19", "20"]}, {"slug": "pg_dependencies", "name": "pg_dependencies", "category": "Character strings", "summary": "multivariate dependencies", "aliases": [], "url": "/wiki/type/pg_dependencies/?v=18", "present_in": ["10", "11", "12", "13", "14", "15", "16", "17", "18", "19", "20"]}, {"slug": "pg_mcv_list", "name": "pg_mcv_list", "category": "Character strings", "summary": "multivariate MCV list", "aliases": [], "url": "/wiki/type/pg_mcv_list/?v=18", "present_in": ["12", "13", "14", "15", "16", "17", "18", "19", "20"]}, {"slug": "pg_ndistinct", "name": "pg_ndistinct", "category": "Character strings", "summary": "multivariate ndistinct coefficients", "aliases": [], "url": "/wiki/type/pg_ndistinct/?v=18", "present_in": ["10", "11", "12", "13", "14", "15", "16", "17", "18", "19", "20"]}, {"slug": "pg_node_tree", "name": "pg_node_tree", "category": "Character strings", "summary": "string representing an internal node tree", "aliases": [], "url": "/wiki/type/pg_node_tree/?v=18", "present_in": ["10", "11", "12", "13", "14", "15", "16", "17", "18", "19", "20"]}, {"slug": "text", "name": "text", "category": "Character strings", "summary": "variable-length character string", "aliases": [], "url": "/wiki/type/text/?v=18", "present_in": ["10", "11", "12", "13", "14", "15", "16", "17", "18", "19", "20"]}, {"slug": "abstime", "name": "abstime", "category": "Date and time", "summary": "Not recorded in the selected version.", "aliases": [], "url": "/wiki/type/abstime/?v=18", "present_in": ["10", "11"]}, {"slug": "date", "name": "date", "category": "Date and time", "summary": "calendar date (year, month, day)", "aliases": [], "url": "/wiki/type/date/?v=18", "present_in": ["10", "11", "12", "13", "14", "15", "16", "17", "18", "19", "20"]}, {"slug": "interval", "name": "interval", "category": "Date and time", "summary": "time span", "aliases": [], "url": "/wiki/type/interval/?v=18", "present_in": ["10", "11", "12", "13", "14", "15", "16", "17", "18", "19", "20"]}, {"slug": "reltime", "name": "reltime", "category": "Date and time", "summary": "Not recorded in the selected version.", "aliases": [], "url": "/wiki/type/reltime/?v=18", "present_in": ["10", "11"]}, {"slug": "timetz", "name": "time with time zone", "category": "Date and time", "summary": "time of day, including time zone", "aliases": ["timetz"], "url": "/wiki/type/timetz/?v=18", "present_in": ["10", "11", "12", "13", "14", "15", "16", "17", "18", "19", "20"]}, {"slug": "time", "name": "time without time zone", "category": "Date and time", "summary": "time of day (no time zone)", "aliases": ["time"], "url": "/wiki/type/time/?v=18", "present_in": ["10", "11", "12", "13", "14", "15", "16", "17", "18", "19", "20"]}, {"slug": "timestamptz", "name": "timestamp with time zone", "category": "Date and time", "summary": "date and time, including time zone", "aliases": ["timestamptz"], "url": "/wiki/type/timestamptz/?v=18", "present_in": ["10", "11", "12", "13", "14", "15", "16", "17", "18", "19", "20"]}, {"slug": "timestamp", "name": "timestamp without time zone", "category": "Date and time", "summary": "date and time (no time zone)", "aliases": ["timestamp"], "url": "/wiki/type/timestamp/?v=18", "present_in": ["10", "11", "12", "13", "14", "15", "16", "17", "18", "19", "20"]}, {"slug": "tinterval", "name": "tinterval", "category": "Date and time", "summary": "Not recorded in the selected version.", "aliases": [], "url": "/wiki/type/tinterval/?v=18", "present_in": ["10", "11"]}, {"slug": "box", "name": "box", "category": "Geometric", "summary": "rectangular box on a plane", "aliases": [], "url": "/wiki/type/box/?v=18", "present_in": ["10", "11", "12", "13", "14", "15", "16", "17", "18", "19", "20"]}, {"slug": "circle", "name": "circle", "category": "Geometric", "summary": "circle on a plane", "aliases": [], "url": "/wiki/type/circle/?v=18", "present_in": ["10", "11", "12", "13", "14", "15", "16", "17", "18", "19", "20"]}, {"slug": "line", "name": "line", "category": "Geometric", "summary": "infinite line on a plane", "aliases": [], "url": "/wiki/type/line/?v=18", "present_in": ["10", "11", "12", "13", "14", "15", "16", "17", "18", "19", "20"]}, {"slug": "lseg", "name": "lseg", "category": "Geometric", "summary": "line segment on a plane", "aliases": [], "url": "/wiki/type/lseg/?v=18", "present_in": ["10", "11", "12", "13", "14", "15", "16", "17", "18", "19", "20"]}, {"slug": "path", "name": "path", "category": "Geometric", "summary": "geometric path on a plane", "aliases": [], "url": "/wiki/type/path/?v=18", "present_in": ["10", "11", "12", "13", "14", "15", "16", "17", "18", "19", "20"]}, {"slug": "point", "name": "point", "category": "Geometric", "summary": "geometric point on a plane", "aliases": [], "url": "/wiki/type/point/?v=18", "present_in": ["10", "11", "12", "13", "14", "15", "16", "17", "18", "19", "20"]}, {"slug": "polygon", "name": "polygon", "category": "Geometric", "summary": "closed geometric path on a plane", "aliases": [], "url": "/wiki/type/polygon/?v=18", "present_in": ["10", "11", "12", "13", "14", "15", "16", "17", "18", "19", "20"]}, {"slug": "int2vector", "name": "int2vector", "category": "Internal and special-purpose", "summary": "array of int2, used in system tables", "aliases": [], "url": "/wiki/type/int2vector/?v=18", "present_in": ["10", "11", "12", "13", "14", "15", "16", "17", "18", "19", "20"]}, {"slug": "oidvector", "name": "oidvector", "category": "Internal and special-purpose", "summary": "array of oids, used in system tables", "aliases": [], "url": "/wiki/type/oidvector/?v=18", "present_in": ["10", "11", "12", "13", "14", "15", "16", "17", "18", "19", "20"]}, {"slug": "json", "name": "json", "category": "JSON", "summary": "textual JSON data", "aliases": [], "url": "/wiki/type/json/?v=18", "present_in": ["10", "11", "12", "13", "14", "15", "16", "17", "18", "19", "20"]}, {"slug": "jsonb", "name": "jsonb", "category": "JSON", "summary": "binary JSON data, decomposed", "aliases": [], "url": "/wiki/type/jsonb/?v=18", "present_in": ["10", "11", "12", "13", "14", "15", "16", "17", "18", "19", "20"]}, {"slug": "jsonpath", "name": "jsonpath", "category": "JSON", "summary": "JSON path", "aliases": [], "url": "/wiki/type/jsonpath/?v=18", "present_in": ["12", "13", "14", "15", "16", "17", "18", "19", "20"]}, {"slug": "datemultirange", "name": "datemultirange", "category": "Multiranges", "summary": "multirange of dates", "aliases": [], "url": "/wiki/type/datemultirange/?v=18", "present_in": ["14", "15", "16", "17", "18", "19", "20"]}, {"slug": "int4multirange", "name": "int4multirange", "category": "Multiranges", "summary": "multirange of integers", "aliases": [], "url": "/wiki/type/int4multirange/?v=18", "present_in": ["14", "15", "16", "17", "18", "19", "20"]}, {"slug": "int8multirange", "name": "int8multirange", "category": "Multiranges", "summary": "multirange of bigints", "aliases": [], "url": "/wiki/type/int8multirange/?v=18", "present_in": ["14", "15", "16", "17", "18", "19", "20"]}, {"slug": "nummultirange", "name": "nummultirange", "category": "Multiranges", "summary": "multirange of numerics", "aliases": [], "url": "/wiki/type/nummultirange/?v=18", "present_in": ["14", "15", "16", "17", "18", "19", "20"]}, {"slug": "tsmultirange", "name": "tsmultirange", "category": "Multiranges", "summary": "multirange of timestamps without time zone", "aliases": [], "url": "/wiki/type/tsmultirange/?v=18", "present_in": ["14", "15", "16", "17", "18", "19", "20"]}, {"slug": "tstzmultirange", "name": "tstzmultirange", "category": "Multiranges", "summary": "multirange of timestamps with time zone", "aliases": [], "url": "/wiki/type/tstzmultirange/?v=18", "present_in": ["14", "15", "16", "17", "18", "19", "20"]}, {"slug": "cidr", "name": "cidr", "category": "Network addresses", "summary": "IPv4 or IPv6 network address", "aliases": [], "url": "/wiki/type/cidr/?v=18", "present_in": ["10", "11", "12", "13", "14", "15", "16", "17", "18", "19", "20"]}, {"slug": "inet", "name": "inet", "category": "Network addresses", "summary": "IPv4 or IPv6 host address", "aliases": [], "url": "/wiki/type/inet/?v=18", "present_in": ["10", "11", "12", "13", "14", "15", "16", "17", "18", "19", "20"]}, {"slug": "int8", "name": "bigint", "category": "Numeric", "summary": "signed eight-byte integer", "aliases": ["int8"], "url": "/wiki/type/int8/?v=18", "present_in": ["10", "11", "12", "13", "14", "15", "16", "17", "18", "19", "20"]}, {"slug": "float8", "name": "double precision", "category": "Numeric", "summary": "double precision floating-point number (8 bytes)", "aliases": ["float", "float8"], "url": "/wiki/type/float8/?v=18", "present_in": ["10", "11", "12", "13", "14", "15", "16", "17", "18", "19", "20"]}, {"slug": "int4", "name": "integer", "category": "Numeric", "summary": "signed four-byte integer", "aliases": ["int", "int4"], "url": "/wiki/type/int4/?v=18", "present_in": ["10", "11", "12", "13", "14", "15", "16", "17", "18", "19", "20"]}, {"slug": "money", "name": "money", "category": "Numeric", "summary": "currency amount", "aliases": [], "url": "/wiki/type/money/?v=18", "present_in": ["10", "11", "12", "13", "14", "15", "16", "17", "18", "19", "20"]}, {"slug": "numeric", "name": "numeric", "category": "Numeric", "summary": "exact numeric of selectable precision", "aliases": ["decimal [ ( p , s ) ]"], "url": "/wiki/type/numeric/?v=18", "present_in": ["10", "11", "12", "13", "14", "15", "16", "17", "18", "19", "20"]}, {"slug": "float4", "name": "real", "category": "Numeric", "summary": "single precision floating-point number (4 bytes)", "aliases": ["float4"], "url": "/wiki/type/float4/?v=18", "present_in": ["10", "11", "12", "13", "14", "15", "16", "17", "18", "19", "20"]}, {"slug": "int2", "name": "smallint", "category": "Numeric", "summary": "signed two-byte integer", "aliases": ["int2"], "url": "/wiki/type/int2/?v=18", "present_in": ["10", "11", "12", "13", "14", "15", "16", "17", "18", "19", "20"]}, {"slug": "cid", "name": "cid", "category": "Object and transaction identifiers", "summary": "command identifier type, sequence in transaction id", "aliases": [], "url": "/wiki/type/cid/?v=18", "present_in": ["10", "11", "12", "13", "14", "15", "16", "17", "18", "19", "20"]}, {"slug": "oid", "name": "oid", "category": "Object and transaction identifiers", "summary": "numeric object identifier", "aliases": [], "url": "/wiki/type/oid/?v=18", "present_in": ["10", "11", "12", "13", "14", "15", "16", "17", "18", "19", "20"]}, {"slug": "oid8", "name": "oid8", "category": "Object and transaction identifiers", "summary": "Not recorded in the selected version.", "aliases": [], "url": "/wiki/type/oid8/?v=18", "present_in": ["19", "20"]}, {"slug": "regclass", "name": "regclass", "category": "Object and transaction identifiers", "summary": "relation name", "aliases": [], "url": "/wiki/type/regclass/?v=18", "present_in": ["10", "11", "12", "13", "14", "15", "16", "17", "18", "19", "20"]}, {"slug": "regcollation", "name": "regcollation", "category": "Object and transaction identifiers", "summary": "collation name", "aliases": [], "url": "/wiki/type/regcollation/?v=18", "present_in": ["13", "14", "15", "16", "17", "18", "19", "20"]}, {"slug": "regconfig", "name": "regconfig", "category": "Object and transaction identifiers", "summary": "text search configuration", "aliases": [], "url": "/wiki/type/regconfig/?v=18", "present_in": ["10", "11", "12", "13", "14", "15", "16", "17", "18", "19", "20"]}, {"slug": "regdatabase", "name": "regdatabase", "category": "Object and transaction identifiers", "summary": "Not recorded in the selected version.", "aliases": [], "url": "/wiki/type/regdatabase/?v=18", "present_in": ["19", "20"]}, {"slug": "regdictionary", "name": "regdictionary", "category": "Object and transaction identifiers", "summary": "text search dictionary", "aliases": [], "url": "/wiki/type/regdictionary/?v=18", "present_in": ["10", "11", "12", "13", "14", "15", "16", "17", "18", "19", "20"]}, {"slug": "regnamespace", "name": "regnamespace", "category": "Object and transaction identifiers", "summary": "namespace name", "aliases": [], "url": "/wiki/type/regnamespace/?v=18", "present_in": ["10", "11", "12", "13", "14", "15", "16", "17", "18", "19", "20"]}, {"slug": "regoper", "name": "regoper", "category": "Object and transaction identifiers", "summary": "operator name", "aliases": [], "url": "/wiki/type/regoper/?v=18", "present_in": ["10", "11", "12", "13", "14", "15", "16", "17", "18", "19", "20"]}, {"slug": "regoperator", "name": "regoperator", "category": "Object and transaction identifiers", "summary": "operator with argument types", "aliases": [], "url": "/wiki/type/regoperator/?v=18", "present_in": ["10", "11", "12", "13", "14", "15", "16", "17", "18", "19", "20"]}, {"slug": "regproc", "name": "regproc", "category": "Object and transaction identifiers", "summary": "function name", "aliases": [], "url": "/wiki/type/regproc/?v=18", "present_in": ["10", "11", "12", "13", "14", "15", "16", "17", "18", "19", "20"]}, {"slug": "regprocedure", "name": "regprocedure", "category": "Object and transaction identifiers", "summary": "function with argument types", "aliases": [], "url": "/wiki/type/regprocedure/?v=18", "present_in": ["10", "11", "12", "13", "14", "15", "16", "17", "18", "19", "20"]}, {"slug": "regrole", "name": "regrole", "category": "Object and transaction identifiers", "summary": "role name", "aliases": [], "url": "/wiki/type/regrole/?v=18", "present_in": ["10", "11", "12", "13", "14", "15", "16", "17", "18", "19", "20"]}, {"slug": "regtype", "name": "regtype", "category": "Object and transaction identifiers", "summary": "data type name", "aliases": [], "url": "/wiki/type/regtype/?v=18", "present_in": ["10", "11", "12", "13", "14", "15", "16", "17", "18", "19", "20"]}, {"slug": "tid", "name": "tid", "category": "Object and transaction identifiers", "summary": "tuple physical location, format '(block,offset)'", "aliases": [], "url": "/wiki/type/tid/?v=18", "present_in": ["10", "11", "12", "13", "14", "15", "16", "17", "18", "19", "20"]}, {"slug": "xid", "name": "xid", "category": "Object and transaction identifiers", "summary": "transaction id", "aliases": [], "url": "/wiki/type/xid/?v=18", "present_in": ["10", "11", "12", "13", "14", "15", "16", "17", "18", "19", "20"]}, {"slug": "xid8", "name": "xid8", "category": "Object and transaction identifiers", "summary": "full transaction id", "aliases": [], "url": "/wiki/type/xid8/?v=18", "present_in": ["13", "14", "15", "16", "17", "18", "19", "20"]}, {"slug": "aclitem", "name": "aclitem", "category": "Other built-in types", "summary": "access control list", "aliases": [], "url": "/wiki/type/aclitem/?v=18", "present_in": ["10", "11", "12", "13", "14", "15", "16", "17", "18", "19", "20"]}, {"slug": "bytea", "name": "bytea", "category": "Other built-in types", "summary": "binary data ( “ byte array ” )", "aliases": [], "url": "/wiki/type/bytea/?v=18", "present_in": ["10", "11", "12", "13", "14", "15", "16", "17", "18", "19", "20"]}, {"slug": "gtsvector", "name": "gtsvector", "category": "Other built-in types", "summary": "GiST index internal text representation for text search", "aliases": [], "url": "/wiki/type/gtsvector/?v=18", "present_in": ["10", "11", "12", "13", "14", "15", "16", "17", "18", "19", "20"]}, {"slug": "macaddr", "name": "macaddr", "category": "Other built-in types", "summary": "MAC (Media Access Control) address", "aliases": [], "url": "/wiki/type/macaddr/?v=18", "present_in": ["10", "11", "12", "13", "14", "15", "16", "17", "18", "19", "20"]}, {"slug": "macaddr8", "name": "macaddr8", "category": "Other built-in types", "summary": "MAC (Media Access Control) address (EUI-64 format)", "aliases": [], "url": "/wiki/type/macaddr8/?v=18", "present_in": ["10", "11", "12", "13", "14", "15", "16", "17", "18", "19", "20"]}, {"slug": "pg_lsn", "name": "pg_lsn", "category": "Other built-in types", "summary": "PostgreSQL Log Sequence Number", "aliases": [], "url": "/wiki/type/pg_lsn/?v=18", "present_in": ["10", "11", "12", "13", "14", "15", "16", "17", "18", "19", "20"]}, {"slug": "pg_snapshot", "name": "pg_snapshot", "category": "Other built-in types", "summary": "user-level transaction ID snapshot", "aliases": [], "url": "/wiki/type/pg_snapshot/?v=18", "present_in": ["13", "14", "15", "16", "17", "18", "19", "20"]}, {"slug": "refcursor", "name": "refcursor", "category": "Other built-in types", "summary": "reference to cursor (portal name)", "aliases": [], "url": "/wiki/type/refcursor/?v=18", "present_in": ["10", "11", "12", "13", "14", "15", "16", "17", "18", "19", "20"]}, {"slug": "smgr", "name": "smgr", "category": "Other built-in types", "summary": "Not recorded in the selected version.", "aliases": [], "url": "/wiki/type/smgr/?v=18", "present_in": ["10", "11"]}, {"slug": "txid_snapshot", "name": "txid_snapshot", "category": "Other built-in types", "summary": "user-level transaction ID snapshot (deprecated; see pg_snapshot )", "aliases": [], "url": "/wiki/type/txid_snapshot/?v=18", "present_in": ["10", "11", "12", "13", "14", "15", "16", "17", "18", "19", "20"]}, {"slug": "uuid", "name": "uuid", "category": "Other built-in types", "summary": "universally unique identifier", "aliases": [], "url": "/wiki/type/uuid/?v=18", "present_in": ["10", "11", "12", "13", "14", "15", "16", "17", "18", "19", "20"]}, {"slug": "xml", "name": "xml", "category": "Other built-in types", "summary": "XML data", "aliases": [], "url": "/wiki/type/xml/?v=18", "present_in": ["10", "11", "12", "13", "14", "15", "16", "17", "18", "19", "20"]}, {"slug": "any", "name": "any", "category": "Pseudo-types", "summary": "Indicates that a function accepts any input data type.", "aliases": [], "url": "/wiki/type/any/?v=18", "present_in": ["10", "11", "12", "13", "14", "15", "16", "17", "18", "19", "20"]}, {"slug": "anyarray", "name": "anyarray", "category": "Pseudo-types", "summary": "Indicates that a function accepts any array data type (see Section 36.2.5 ).", "aliases": [], "url": "/wiki/type/anyarray/?v=18", "present_in": ["10", "11", "12", "13", "14", "15", "16", "17", "18", "19", "20"]}, {"slug": "anycompatible", "name": "anycompatible", "category": "Pseudo-types", "summary": "Indicates that a function accepts any data type, with automatic promotion of multiple arguments to a common data type (see Section 36.2.5 ).", "aliases": [], "url": "/wiki/type/anycompatible/?v=18", "present_in": ["13", "14", "15", "16", "17", "18", "19", "20"]}, {"slug": "anycompatiblearray", "name": "anycompatiblearray", "category": "Pseudo-types", "summary": "Indicates that a function accepts any array data type, with automatic promotion of multiple arguments to a common data type (see Section 36.2.5 ).", "aliases": [], "url": "/wiki/type/anycompatiblearray/?v=18", "present_in": ["13", "14", "15", "16", "17", "18", "19", "20"]}, {"slug": "anycompatiblemultirange", "name": "anycompatiblemultirange", "category": "Pseudo-types", "summary": "Indicates that a function accepts any multirange data type, with automatic promotion of multiple arguments to a common data type (see Section 36.2.5 and Section 8.17 ).", "aliases": [], "url": "/wiki/type/anycompatiblemultirange/?v=18", "present_in": ["14", "15", "16", "17", "18", "19", "20"]}, {"slug": "anycompatiblenonarray", "name": "anycompatiblenonarray", "category": "Pseudo-types", "summary": "Indicates that a function accepts any non-array data type, with automatic promotion of multiple arguments to a common data type (see Section 36.2.5 ).", "aliases": [], "url": "/wiki/type/anycompatiblenonarray/?v=18", "present_in": ["13", "14", "15", "16", "17", "18", "19", "20"]}, {"slug": "anycompatiblerange", "name": "anycompatiblerange", "category": "Pseudo-types", "summary": "Indicates that a function accepts any range data type, with automatic promotion of multiple arguments to a common data type (see Section 36.2.5 and Section 8.17 ).", "aliases": [], "url": "/wiki/type/anycompatiblerange/?v=18", "present_in": ["13", "14", "15", "16", "17", "18", "19", "20"]}, {"slug": "anyelement", "name": "anyelement", "category": "Pseudo-types", "summary": "Indicates that a function accepts any data type (see Section 36.2.5 ).", "aliases": [], "url": "/wiki/type/anyelement/?v=18", "present_in": ["10", "11", "12", "13", "14", "15", "16", "17", "18", "19", "20"]}, {"slug": "anyenum", "name": "anyenum", "category": "Pseudo-types", "summary": "Indicates that a function accepts any enum data type (see Section 36.2.5 and Section 8.7 ).", "aliases": [], "url": "/wiki/type/anyenum/?v=18", "present_in": ["10", "11", "12", "13", "14", "15", "16", "17", "18", "19", "20"]}, {"slug": "anymultirange", "name": "anymultirange", "category": "Pseudo-types", "summary": "Indicates that a function accepts any multirange data type (see Section 36.2.5 and Section 8.17 ).", "aliases": [], "url": "/wiki/type/anymultirange/?v=18", "present_in": ["14", "15", "16", "17", "18", "19", "20"]}, {"slug": "anynonarray", "name": "anynonarray", "category": "Pseudo-types", "summary": "Indicates that a function accepts any non-array data type (see Section 36.2.5 ).", "aliases": [], "url": "/wiki/type/anynonarray/?v=18", "present_in": ["10", "11", "12", "13", "14", "15", "16", "17", "18", "19", "20"]}, {"slug": "anyrange", "name": "anyrange", "category": "Pseudo-types", "summary": "Indicates that a function accepts any range data type (see Section 36.2.5 and Section 8.17 ).", "aliases": [], "url": "/wiki/type/anyrange/?v=18", "present_in": ["10", "11", "12", "13", "14", "15", "16", "17", "18", "19", "20"]}, {"slug": "cstring", "name": "cstring", "category": "Pseudo-types", "summary": "Indicates that a function accepts or returns a null-terminated C string.", "aliases": [], "url": "/wiki/type/cstring/?v=18", "present_in": ["10", "11", "12", "13", "14", "15", "16", "17", "18", "19", "20"]}, {"slug": "event_trigger", "name": "event_trigger", "category": "Pseudo-types", "summary": "An event trigger function is declared to return event_trigger.", "aliases": [], "url": "/wiki/type/event_trigger/?v=18", "present_in": ["10", "11", "12", "13", "14", "15", "16", "17", "18", "19", "20"]}, {"slug": "fdw_handler", "name": "fdw_handler", "category": "Pseudo-types", "summary": "A foreign-data wrapper handler is declared to return fdw_handler .", "aliases": [], "url": "/wiki/type/fdw_handler/?v=18", "present_in": ["10", "11", "12", "13", "14", "15", "16", "17", "18", "19", "20"]}, {"slug": "index_am_handler", "name": "index_am_handler", "category": "Pseudo-types", "summary": "An index access method handler is declared to return index_am_handler .", "aliases": [], "url": "/wiki/type/index_am_handler/?v=18", "present_in": ["10", "11", "12", "13", "14", "15", "16", "17", "18", "19", "20"]}, {"slug": "internal", "name": "internal", "category": "Pseudo-types", "summary": "Indicates that a function accepts or returns a server-internal data type.", "aliases": [], "url": "/wiki/type/internal/?v=18", "present_in": ["10", "11", "12", "13", "14", "15", "16", "17", "18", "19", "20"]}, {"slug": "language_handler", "name": "language_handler", "category": "Pseudo-types", "summary": "A procedural language call handler is declared to return language_handler .", "aliases": [], "url": "/wiki/type/language_handler/?v=18", "present_in": ["10", "11", "12", "13", "14", "15", "16", "17", "18", "19", "20"]}, {"slug": "opaque", "name": "opaque", "category": "Pseudo-types", "summary": "Not recorded in the selected version.", "aliases": [], "url": "/wiki/type/opaque/?v=18", "present_in": ["10", "11", "12"]}, {"slug": "pg_ddl_command", "name": "pg_ddl_command", "category": "Pseudo-types", "summary": "Identifies a representation of DDL commands that is available to event triggers.", "aliases": [], "url": "/wiki/type/pg_ddl_command/?v=18", "present_in": ["10", "11", "12", "13", "14", "15", "16", "17", "18", "19", "20"]}, {"slug": "record", "name": "record", "category": "Pseudo-types", "summary": "Identifies a function taking or returning an unspecified row type.", "aliases": [], "url": "/wiki/type/record/?v=18", "present_in": ["10", "11", "12", "13", "14", "15", "16", "17", "18", "19", "20"]}, {"slug": "table_am_handler", "name": "table_am_handler", "category": "Pseudo-types", "summary": "A table access method handler is declared to return table_am_handler .", "aliases": [], "url": "/wiki/type/table_am_handler/?v=18", "present_in": ["12", "13", "14", "15", "16", "17", "18", "19", "20"]}, {"slug": "trigger", "name": "trigger", "category": "Pseudo-types", "summary": "A trigger function is declared to return trigger.", "aliases": [], "url": "/wiki/type/trigger/?v=18", "present_in": ["10", "11", "12", "13", "14", "15", "16", "17", "18", "19", "20"]}, {"slug": "tsm_handler", "name": "tsm_handler", "category": "Pseudo-types", "summary": "A tablesample method handler is declared to return tsm_handler .", "aliases": [], "url": "/wiki/type/tsm_handler/?v=18", "present_in": ["10", "11", "12", "13", "14", "15", "16", "17", "18", "19", "20"]}, {"slug": "unknown", "name": "unknown", "category": "Pseudo-types", "summary": "Identifies a not-yet-resolved type, e.g., of an undecorated string literal.", "aliases": [], "url": "/wiki/type/unknown/?v=18", "present_in": ["10", "11", "12", "13", "14", "15", "16", "17", "18", "19", "20"]}, {"slug": "void", "name": "void", "category": "Pseudo-types", "summary": "Indicates that a function returns no value.", "aliases": [], "url": "/wiki/type/void/?v=18", "present_in": ["10", "11", "12", "13", "14", "15", "16", "17", "18", "19", "20"]}, {"slug": "daterange", "name": "daterange", "category": "Ranges", "summary": "range of dates", "aliases": [], "url": "/wiki/type/daterange/?v=18", "present_in": ["10", "11", "12", "13", "14", "15", "16", "17", "18", "19", "20"]}, {"slug": "int4range", "name": "int4range", "category": "Ranges", "summary": "range of integers", "aliases": [], "url": "/wiki/type/int4range/?v=18", "present_in": ["10", "11", "12", "13", "14", "15", "16", "17", "18", "19", "20"]}, {"slug": "int8range", "name": "int8range", "category": "Ranges", "summary": "range of bigints", "aliases": [], "url": "/wiki/type/int8range/?v=18", "present_in": ["10", "11", "12", "13", "14", "15", "16", "17", "18", "19", "20"]}, {"slug": "numrange", "name": "numrange", "category": "Ranges", "summary": "range of numerics", "aliases": [], "url": "/wiki/type/numrange/?v=18", "present_in": ["10", "11", "12", "13", "14", "15", "16", "17", "18", "19", "20"]}, {"slug": "tsrange", "name": "tsrange", "category": "Ranges", "summary": "range of timestamps without time zone", "aliases": [], "url": "/wiki/type/tsrange/?v=18", "present_in": ["10", "11", "12", "13", "14", "15", "16", "17", "18", "19", "20"]}, {"slug": "tstzrange", "name": "tstzrange", "category": "Ranges", "summary": "range of timestamps with time zone", "aliases": [], "url": "/wiki/type/tstzrange/?v=18", "present_in": ["10", "11", "12", "13", "14", "15", "16", "17", "18", "19", "20"]}, {"slug": "bigserial", "name": "bigserial", "category": "SQL conveniences", "summary": "autoincrementing eight-byte integer", "aliases": ["serial8"], "url": "/wiki/type/bigserial/?v=18", "present_in": ["10", "11", "12", "13", "14", "15", "16", "17", "18", "19", "20"]}, {"slug": "serial", "name": "serial", "category": "SQL conveniences", "summary": "autoincrementing four-byte integer", "aliases": ["serial4"], "url": "/wiki/type/serial/?v=18", "present_in": ["10", "11", "12", "13", "14", "15", "16", "17", "18", "19", "20"]}, {"slug": "smallserial", "name": "smallserial", "category": "SQL conveniences", "summary": "autoincrementing two-byte integer", "aliases": ["serial2"], "url": "/wiki/type/smallserial/?v=18", "present_in": ["10", "11", "12", "13", "14", "15", "16", "17", "18", "19", "20"]}, {"slug": "tsquery", "name": "tsquery", "category": "Text search", "summary": "text search query", "aliases": [], "url": "/wiki/type/tsquery/?v=18", "present_in": ["10", "11", "12", "13", "14", "15", "16", "17", "18", "19", "20"]}, {"slug": "tsvector", "name": "tsvector", "category": "Text search", "summary": "text search document", "aliases": [], "url": "/wiki/type/tsvector/?v=18", "present_in": ["10", "11", "12", "13", "14", "15", "16", "17", "18", "19", "20"]}, {"slug": "arrays", "name": "Arrays", "category": "Type families", "summary": "PostgreSQL allows columns of a table to be defined as variable-length multidimensional arrays. Arrays of any built-in or user-defined base type, enum type, composite type, range type, or domain can be created.", "aliases": [], "url": "/wiki/type/arrays/?v=18", "present_in": ["10", "11", "12", "13", "14", "15", "16", "17", "18", "19", "20"]}, {"slug": "composite", "name": "Composite types", "category": "Type families", "summary": "A composite type represents the structure of a row or record; it is essentially just a list of field names and their data types. PostgreSQL allows composite types to be used in many of the same ways that simple types can be used. For example, a column of a table can be declared to be of a composite type.", "aliases": [], "url": "/wiki/type/composite/?v=18", "present_in": ["10", "11", "12", "13", "14", "15", "16", "17", "18", "19", "20"]}, {"slug": "domains", "name": "Domains", "category": "Type families", "summary": "A domain is a user-defined data type that is based on another underlying type . Optionally, it can have constraints that restrict its valid values to a subset of what the underlying type would allow. Otherwise it behaves like the underlying type — for example, any operator or function that can be applied to the underlying type will work on the domain type. The underlying type can be any built-in or user-defined base type, enum type, array type, composite type, range type, or another domain.", "aliases": [], "url": "/wiki/type/domains/?v=18", "present_in": ["10", "11", "12", "13", "14", "15", "16", "17", "18", "19", "20"]}, {"slug": "enums", "name": "Enumerated types", "category": "Type families", "summary": "Enumerated (enum) types are data types that comprise a static, ordered set of values. They are equivalent to the enum types supported in a number of programming languages. An example of an enum type might be the days of the week, or a set of status values for a piece of data.", "aliases": [], "url": "/wiki/type/enums/?v=18", "present_in": ["10", "11", "12", "13", "14", "15", "16", "17", "18", "19", "20"]}]}