datahike.pg.types — org.replikativ/pg-datahike 0.1.8

PostgreSQL type system registry for the PgWire compatibility layer.

Centralizes all type mappings between PostgreSQL OIDs, SQL type names, Datahike value types, and wire protocol format codes.

Authoritative source: PostgreSQL 19devel src/include/catalog/pg_type.dat

Three directions of mapping:

1. SQL name → Datahike type (for CREATE TABLE)
2. Datahike type → PG OID (for wire protocol RowDescription)
3. PG OID → SQL name (for format_type() and information_schema)
4. SQL name → category (for CAST type classification)

cast-bit-types clj

SQL type names that cast to a PG bit string — emitted as a string of ASCII '0'/'1' characters in PG's text format. pgjdbc's testgetBadBoolean asserts 29::bit(4) serializes as "1101".

cast-boolean-types clj

SQL type names that cast to boolean.

cast-bytes-types clj

SQL type names that cast to a byte array.

cast-category clj

(cast-category sql-type-name)

Classify a SQL type name for CAST handling. Returns :integer, :float, :text, :boolean, :date, :time, :timestamp, :uuid, :bytes, or nil. :date and :time are checked before :timestamp so callers can emit the display-appropriate Java type (LocalDate / LocalTime vs Instant).

cast-date-types clj

SQL type names that cast to a DATE (no time component). Needed because PG's DATE/TIME/TIMESTAMP all serialize differently in text format — e.g. DATE is '2017-03-13', TIME is '14:25:48', TIMESTAMP is '2017-03-13 14:25:48'. Datahike stores them all as :db.type/instant, so the distinction is only preserved through CAST expressions (where we know the target display type).

cast-float-types clj

SQL type names that cast to floating point (Clojure double).

cast-integer-types clj

SQL type names that cast to integer (Clojure long).

cast-text-types clj

SQL type names that cast to text (Clojure string).

cast-time-types clj

SQL type names that cast to a TIME (no date component).

cast-timestamp-types clj

SQL type names that cast to timestamp/instant.

cast-uuid-types clj

SQL type names that cast to UUID.

dh-type->oid clj

Map Datahike :db/valueType to PostgreSQL type OID for wire protocol.

dh-type->pg-name clj

Map Datahike :db/valueType to PostgreSQL type name string.

dh-type-for-sql-name clj

(dh-type-for-sql-name sql-name)

Return the Datahike valueType for a SQL type name (lowercased).

format-type clj

(format-type type-oid _typmod)

PostgreSQL format_type(oid, typmod) — return type name for an OID.

infer-oid-from-value clj

(infer-oid-from-value v)

Infer a PostgreSQL type OID from a Clojure runtime value.

oid->pg-name clj

Map PostgreSQL type OID to canonical type name string.

oid->wire-size clj

Map OID to type size for RowDescription's typlen field. Positive = fixed size in bytes, -1 = variable length.

oid-bool clj

oid-bpchar clj

oid-bytea clj

oid-date clj

oid-float4 clj

oid-float8 clj

oid-for-dh-type clj

(oid-for-dh-type vtype)

Return the PostgreSQL type OID for a Datahike valueType keyword.

oid-int2 clj

oid-int4 clj

oid-int8 clj

oid-interval clj

oid-json clj

oid-jsonb clj

oid-name clj

oid-numeric clj

oid-oid clj

oid-text clj

oid-time clj

oid-timestamp clj

oid-timestamptz clj

oid-uuid clj

oid-varchar clj

pg-name->oid clj

Map a PostgreSQL type name (the string stored on :pg/type when the column's original SQL type doesn't match the Datahike valueType 1:1 — e.g. date vs timestamp both collapse to :db.type/instant) back to its wire OID. Used by infer-param-oid-for-column so pgjdbc's ParameterDescription sees the SQL-declared type, not our internal reduction.

pg-name-for-dh-type clj

(pg-name-for-dh-type vtype)

Return the PostgreSQL type name string for a Datahike valueType keyword.

pg-type-catalog clj

Common PostgreSQL types for the pg_type virtual table. Each entry: [oid typname typlen typtype]

sql-name->dh-type clj

Map SQL type names (lowercased) to Datahike :db/valueType keywords. Covers all common SQL and PostgreSQL type name variants.

wire-size clj

(wire-size oid)

Return the wire protocol type size for an OID.