The jOOQ User Manual SQL building Data types Built-in data types REAL (Float)

previous : next

REAL (Float)

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

The REAL data type represents a 32 bit floating point number, or java.lang.Float in Java, or Types.REAL in JDBC

DDL support

Dialect support

This example using jOOQ:

createTable("t").column("c", REAL)

Translates to the following dialect specific expressions:

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

CREATE TABLE t (
  c real
)

ASE, Sybase

CREATE TABLE t (
  c real NULL
)

BigQuery

CREATE TABLE t (
  c float64
)

ClickHouse

CREATE TABLE t (
  c Nullable(real)
)
ENGINE Log()

Databricks

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

Firebird

CREATE TABLE t (
  c float
)

Informix

CREATE TABLE t (
  c smallfloat
)

Cast support

Dialect support

This example using jOOQ:

cast(field("c"), REAL)

Translates to the following dialect specific expressions:

Access

csng(c)

ASE, Aurora Postgres, CockroachDB, DB2, Derby, DuckDB, Exasol, H2, HSQLDB, Hana, Oracle, Postgres, Redshift, SQLDataWarehouse, SQLServer, SQLite, Snowflake, Sybase, Teradata, Trino, Vertica, YugabyteDB

CAST(c AS real)

Aurora MySQL, MariaDB, MemSQL, MySQL

CAST(c AS decimal)

BigQuery

CAST(c AS float64)

ClickHouse

CAST(c AS Nullable(real))

Databricks, Firebird

CAST(c AS float)

Informix

CAST(c AS smallfloat)

The jOOQ User Manual SQL building Data types Built-in data types REAL (Float)

previous : next