decimal Data Type

decimal data expresses an exact number with user-defined precision and scale.

Syntax

Field	Definition
Eexp	Multiply the number preceeding E by 10^exp

Field	Definition
precision	The total number of decimal values to track, e.g., `100` has a precision of 3. However, all `decimal` values in Materialize have a precision of 38.
scale	The total number of fractional decimal values to track, e.g. `.321` has a scale of 3. scale cannot exceed the maximum precision.

Materialize assumes untyped numeric literals containing decimal points or e-notation are decimal.
By default, Materialize uses 38 precision and 0 scale, as per the SQL standard.
Materialize allows you to set the scale to any value in the set (0, 38); however, the precision cannot be changed from 38.

You can cast decimal to:

You can cast the following types to decimal:

SELECT 1.23::decimal AS dec_v;

 dec_v
-------
     1

SELECT 1.23::decimal(38,3) AS dec_38_3_v;

 dec_38_3_v
------------
      1.230

SELECT 1.23e4 AS dec_w_exp;

 dec_w_exp
-----------
     12300