select open change scope Open full search

PG.CENTER connects PostgreSQL documentation, reference, and ecosystem knowledge. Maintained by Pigsty.

Extensions / Data types

decimal

Decimal32 and decimal64 decimal floating-point data types with arithmetic and casts

pgext.cloud · Source code · Documentation · License text · Control file · PGXN

Overview

PackagepgDecimal
Version1.0
RepositoryUnspecified
Extension typeStandard
Requires CREATE EXTENSIONYes
Requires preloadNo
TrustedNo
RelocatableYes
Stars1
Latest commit2013-06-04
Latest release2013-06-04
Catalogue updated2026-08-30

Related extensions

See also

ksjJapanese kanji-numeral integer type with arithmetic, aggregates, casts, comparison, and B-tree indexing
fixeddecimalFixed-precision decimal type optimized for performance and storage.
uintsC extension providing unsigned 16-bit and 32-bit integer types with casts, operators, and numeric support functions.
sum_arrayC function that sums PostgreSQL integer and floating-point arrays into float8.
numeric_domainsCustom numeric domains for PostgreSQL
numpgsqlArray and numerical computing library for PostgreSQL
pg_phashCalculate Hamming distance between decimal-encoded perceptual image hashes
bignumUnlimited precision integers for PostgreSQL