The jOOQ User Manual SQL building Data types Built-in data types DECFLOAT (Decfloat)

previous : next

DECFLOAT (Decfloat)

Supported by ✅ Open Source Edition   ✅ Express Edition   ✅ Professional Edition   ✅ Enterprise Edition

The DECFLOAT data type represents a variable bit floating point number, optimised for decimal values as opposed to binary ones, or org.jooq.Decfloat in Java. It has no representation in JDBC.

DDL support

Dialect support

This example using jOOQ:

createTable("t").column("c", DECFLOAT(20))

Translates to the following dialect specific expressions:

Access, Aurora MySQL, Aurora Postgres, CockroachDB, DB2, Derby, DuckDB, Exasol, Firebird, H2, HSQLDB, Informix, MariaDB, MemSQL, MySQL, Oracle, Postgres, Redshift, SQLDataWarehouse, SQLServer, SQLite, Snowflake, Teradata, Trino, Vertica, YugabyteDB

CREATE TABLE t (
  c decfloat(20)
)

ASE, Sybase

CREATE TABLE t (
  c decfloat(20) NULL
)

BigQuery

CREATE TABLE t (
  c decfloat
)

ClickHouse

CREATE TABLE t (
  c Nullable(decfloat(20))
)
ENGINE Log()

Databricks

CREATE TABLE t (
  c decfloat(20)
)
TBLPROPERTIES(
  'delta.columnMapping.mode' = 'name',
  'delta.feature.allowColumnDefaults' = 'supported'
)

Hana

CREATE TABLE t (
  c smalldecimal(20)
)

Cast support

Dialect support

This example using jOOQ:

cast(field("c"), DECFLOAT(20))

Translates to the following dialect specific expressions:

Access

cdec(c)

ASE, Aurora MySQL, Aurora Postgres, CockroachDB, DB2, Databricks, Derby, DuckDB, Exasol, Firebird, H2, HSQLDB, Informix, MariaDB, MemSQL, MySQL, Oracle, Postgres, Redshift, SQLDataWarehouse, SQLServer, SQLite, Snowflake, Sybase, Teradata, Trino, Vertica, YugabyteDB

CAST(c AS decfloat(20))

BigQuery

CAST(c AS decfloat)

ClickHouse

CAST(c AS Nullable(decfloat(20)))

Hana

CAST(c AS smalldecimal(20))

The jOOQ User Manual SQL building Data types Built-in data types DECFLOAT (Decfloat)

previous : next