sql::ast

Enum DataType

pub enum DataType {
Show 110 variants
    Table(Option<Vec<ColumnDef>>),
    NamedTable {
        name: ObjectName,
        columns: Vec<ColumnDef>,
    },
    Character(Option<CharacterLength>),
    Char(Option<CharacterLength>),
    CharacterVarying(Option<CharacterLength>),
    CharVarying(Option<CharacterLength>),
    Varchar(Option<CharacterLength>),
    Nvarchar(Option<CharacterLength>),
    Uuid,
    CharacterLargeObject(Option<u64>),
    CharLargeObject(Option<u64>),
    Clob(Option<u64>),
    Binary(Option<u64>),
    Varbinary(Option<BinaryLength>),
    Blob(Option<u64>),
    TinyBlob,
    MediumBlob,
    LongBlob,
    Bytes(Option<u64>),
    Numeric(ExactNumberInfo),
    Decimal(ExactNumberInfo),
    BigNumeric(ExactNumberInfo),
    BigDecimal(ExactNumberInfo),
    Dec(ExactNumberInfo),
    Float(Option<u64>),
    TinyInt(Option<u64>),
    TinyIntUnsigned(Option<u64>),
    UTinyInt,
    Int2(Option<u64>),
    Int2Unsigned(Option<u64>),
    SmallInt(Option<u64>),
    SmallIntUnsigned(Option<u64>),
    USmallInt,
    MediumInt(Option<u64>),
    MediumIntUnsigned(Option<u64>),
    Int(Option<u64>),
    Int4(Option<u64>),
    Int8(Option<u64>),
    Int16,
    Int32,
    Int64,
    Int128,
    Int256,
    Integer(Option<u64>),
    IntUnsigned(Option<u64>),
    Int4Unsigned(Option<u64>),
    IntegerUnsigned(Option<u64>),
    HugeInt,
    UHugeInt,
    UInt8,
    UInt16,
    UInt32,
    UInt64,
    UInt128,
    UInt256,
    BigInt(Option<u64>),
    BigIntUnsigned(Option<u64>),
    UBigInt,
    Int8Unsigned(Option<u64>),
    Signed,
    SignedInteger,
    Unsigned,
    UnsignedInteger,
    Float4,
    Float32,
    Float64,
    Real,
    Float8,
    Double(ExactNumberInfo),
    DoublePrecision,
    Bool,
    Boolean,
    Date,
    Date32,
    Time(Option<u64>, TimezoneInfo),
    Datetime(Option<u64>),
    Datetime64(u64, Option<String>),
    Timestamp(Option<u64>, TimezoneInfo),
    TimestampNtz,
    Interval,
    JSON,
    JSONB,
    Regclass,
    Text,
    TinyText,
    MediumText,
    LongText,
    String(Option<u64>),
    FixedString(u64),
    Bytea,
    Bit(Option<u64>),
    BitVarying(Option<u64>),
    VarBit(Option<u64>),
    Custom(ObjectName, Vec<String>),
    Array(ArrayElemTypeDef),
    Map(Box<DataType>, Box<DataType>),
    Tuple(Vec<StructField>),
    Nested(Vec<ColumnDef>),
    Enum(Vec<EnumMember>, Option<u8>),
    Set(Vec<String>),
    Struct(Vec<StructField>, StructBracketKind),
    Union(Vec<UnionField>),
    Nullable(Box<DataType>),
    LowCardinality(Box<DataType>),
    Unspecified,
    Trigger,
    AnyType,
    GeometricType(GeometricTypeKind),
    TsVector,
    TsQuery,
}

Expand description

SQL data types

Variants§

§

Table(Option<Vec<ColumnDef>>)

Table type in PostgreSQL, e.g. CREATE FUNCTION RETURNS TABLE(…).

§

NamedTable

Table type with a name, e.g. CREATE FUNCTION RETURNS @result TABLE(…).

Fields

§name: ObjectName

Table name.

§columns: Vec<ColumnDef>

Table columns.

§

Character(Option<CharacterLength>)

Fixed-length character type, e.g. CHARACTER(10).

§

Char(Option<CharacterLength>)

Fixed-length char type, e.g. CHAR(10).

§

CharacterVarying(Option<CharacterLength>)

Character varying type, e.g. CHARACTER VARYING(10).

§

CharVarying(Option<CharacterLength>)

Char varying type, e.g. CHAR VARYING(10).

§

Varchar(Option<CharacterLength>)

Variable-length character type, e.g. VARCHAR(10).

§

Nvarchar(Option<CharacterLength>)

Variable-length character type, e.g. NVARCHAR(10).

§

Uuid

Uuid type.

§

CharacterLargeObject(Option<u64>)

Large character object with optional length, e.g. CHARACTER LARGE OBJECT, CHARACTER LARGE OBJECT(1000), SQL Standard.

§

CharLargeObject(Option<u64>)

Large character object with optional length, e.g. CHAR LARGE OBJECT, CHAR LARGE OBJECT(1000), SQL Standard.

§

Clob(Option<u64>)

Large character object with optional length, e.g. CLOB, CLOB(1000), SQL Standard.

§

Binary(Option<u64>)

Fixed-length binary type with optional length, see SQL Standard, MS SQL Server.

§

Varbinary(Option<BinaryLength>)

Variable-length binary with optional length type, see SQL Standard, MS SQL Server.

§

Blob(Option<u64>)

Large binary object with optional length, see SQL Standard, Oracle.

§

TinyBlob

MySQL blob with up to 2**8 bytes.

§

MediumBlob

MySQL blob with up to 2**24 bytes.

§

LongBlob

MySQL blob with up to 2**32 bytes.

§

Bytes(Option<u64>)

Variable-length binary data with optional length.

§

Numeric(ExactNumberInfo)

Numeric type with optional precision and scale, e.g. NUMERIC(10,2), SQL Standard.

§

Decimal(ExactNumberInfo)

Decimal type with optional precision and scale, e.g. DECIMAL(10,2), SQL Standard.

§

BigNumeric(ExactNumberInfo)

BigNumeric type used in BigQuery.

§

BigDecimal(ExactNumberInfo)

This is alias for BigNumeric type used in BigQuery.

§

Dec(ExactNumberInfo)

Dec type with optional precision and scale, e.g. DEC(10,2), SQL Standard.

§

Float(Option<u64>)

Floating point with optional precision, e.g. FLOAT(8).

§

TinyInt(Option<u64>)

Tiny integer with optional display width, e.g. TINYINT or TINYINT(3).

§

TinyIntUnsigned(Option<u64>)

Unsigned tiny integer with optional display width, e.g. TINYINT UNSIGNED or TINYINT(3) UNSIGNED.

§

UTinyInt

Unsigned tiny integer, e.g. UTINYINT

§

Int2(Option<u64>)

Int2 is an alias for SmallInt in PostgreSQL. Note: Int2 means 2 bytes in PostgreSQL (not 2 bits). Int2 with optional display width, e.g. INT2 or INT2(5).

§

Int2Unsigned(Option<u64>)

Unsigned Int2 with optional display width, e.g. INT2 UNSIGNED or INT2(5) UNSIGNED.

§

SmallInt(Option<u64>)

Small integer with optional display width, e.g. SMALLINT or SMALLINT(5).

§

SmallIntUnsigned(Option<u64>)

Unsigned small integer with optional display width, e.g. SMALLINT UNSIGNED or SMALLINT(5) UNSIGNED.

§

USmallInt

Unsigned small integer, e.g. USMALLINT.

§

MediumInt(Option<u64>)

MySQL medium integer (1) with optional display width, e.g. MEDIUMINT or MEDIUMINT(5).

§

MediumIntUnsigned(Option<u64>)

Unsigned medium integer (1) with optional display width, e.g. MEDIUMINT UNSIGNED or MEDIUMINT(5) UNSIGNED.

§

Int(Option<u64>)

Int with optional display width, e.g. INT or INT(11).

§

Int4(Option<u64>)

Int4 is an alias for Integer in PostgreSQL. Note: Int4 means 4 bytes in PostgreSQL (not 4 bits). Int4 with optional display width, e.g. Int4 or Int4(11).

§

Int8(Option<u64>)

Int8 is an alias for BigInt in PostgreSQL and Integer type in ClickHouse. Int8 with optional display width, e.g. INT8 or INT8(11). Note: Int8 means 8 bytes in PostgreSQL, but 8 bits in ClickHouse.

§