Enum ColumnTypeName 

pub enum ColumnTypeName {
    SmallInt,
    Int,
    BigInt,
    Float,
    Text,
    Varchar(u32),
    Char(u32),
    Bool,
    Vector {
        dim: u32,
        encoding: VecEncoding,
    },
    Numeric(u8, u8),
    Date,
    Timestamp,
    Timestamptz,
    Json,
    Jsonb,
    Bytes,
    TextArray,
    IntArray,
    BigIntArray,
}

SQL-level type names. The mapping to the storage runtime’s DataType happens in spg-engine — keeping spg-sql free of storage deps.

Variants

SmallInt

Int

BigInt

Float

Text

Varchar(u32)

VARCHAR(N) — TEXT capped at N Unicode characters.

Char(u32)

CHAR(N) — TEXT right-padded with spaces to exactly N characters.

Bool

Vector

pgvector fixed-dimension VECTOR(N). v6.0.1 added the USING <encoding> clause; omitting it surfaces as encoding = VecEncoding::F32 (the pre-v6 default).

Fields

dim: u32

encoding: VecEncoding

Numeric(u8, u8)

NUMERIC / NUMERIC(p) / NUMERIC(p, s) — exact decimal. Bare NUMERIC and NUMERIC(p) both surface with scale=0.

Date

DATE — calendar day, no time-of-day component.

Timestamp

TIMESTAMP / MySQL DATETIME — instant with microsecond precision.

Timestamptz

v7.9.2 TIMESTAMPTZ / TIMESTAMP WITH TIME ZONE. SPG stores all timestamps as UTC microseconds-since-epoch and does not carry per-row offset (PG’s internal representation is the same — TZ is a display convention). The distinction from TIMESTAMP exists for the PG-wire layer to advertise OID 1184 so sqlx-style clients decode into chrono::DateTime<Utc> instead of NaiveDateTime.

Json

v4.9 JSON — text-backed JSON document. No parse-time validation; the engine round-trips the literal verbatim. PG OID 114 on the wire.

Jsonb

v7.9.0 JSONB — same storage shape as Json, advertised as PG OID 3802 on the wire so sqlx-style binary-typed clients decode without a custom type registration.

Bytes

v7.10.4 BYTES / BYTEA — raw binary blob. PG wire OID 17. Literal forms (decoded by the engine at coercion time):

• PG hex form: '\xDEADBEEF'
• Escape form: 'foo\\000bar' (backslash octal triples)

TextArray

v7.10.10 TEXT[] — single-dimension TEXT array. PG wire OID 1009. Literal forms accepted by the parser:

• ARRAY['a', 'b', NULL]
• '{a,b,NULL}'::TEXT[] (engine decodes the external form at coerce time)

IntArray

v7.11.13 INT[] — single-dimension i32 array. PG wire OID 1007. Same literal forms as TEXT[] (substituting integer elements).

BigIntArray

v7.11.13 BIGINT[] — single-dimension i64 array. PG wire OID 1016.

Trait Implementations

impl Clone for ColumnTypeName

fn clone(&self) -> ColumnTypeName

Returns a duplicate of the value.

fn clone_from(&mut self, source: &Self)

Performs copy-assignment from source.

impl Copy for ColumnTypeName

impl Debug for ColumnTypeName

fn fmt(&self, f: &mut Formatter<'_>) -> Result

Formats the value using the given formatter.

impl Display for ColumnTypeName

fn fmt(&self, f: &mut Formatter<'_>) -> Result

Formats the value using the given formatter.

impl Eq for ColumnTypeName

impl PartialEq for ColumnTypeName

fn eq(&self, other: &ColumnTypeName) -> bool

Tests for self and other values to be equal, and is used by ==.

fn ne(&self, other: &Rhs) -> bool

Tests for !=. The default implementation is almost always sufficient, and should not be overridden without very good reason.

impl StructuralPartialEq for ColumnTypeName