Approximate Numeric Type

A floating-point numeric type that may store an approximation of a value.

What is Approximate Numeric Type in a relational database?

Approximate Numeric Type — A floating-point numeric type that may store an approximation of a value.

CREATE TABLE measurement (
    reading DOUBLE PRECISION NOT NULL
);

Level: Apprentice · More Database terms at this level

Updated September 27, 2026