DEC, NUMERIC, FIXED

Synonyms for DECIMAL. These keywords declare fixed-point numbers, which store exact numeric data with a defined precision and scale.

Syntax

DEC[(M[,D])] [SIGNED | UNSIGNED | ZEROFILL]

NUMERIC[(M[,D])] [SIGNED | UNSIGNED | ZEROFILL]

FIXED[(M[,D])] [SIGNED | UNSIGNED | ZEROFILL]

Description

These types are synonyms for DECIMAL. The FIXED synonym is available for compatibility with other database systems.

_{This page is licensed: GPLv2, originally from fill_help_tables.sql}