select open change scope Open full search

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

Extensions / Data types

fixeddecimal

Fixed-precision decimal type optimized for performance and storage.

pgext.cloud · Source code · Documentation · Control file

Overview

Packagefixeddecimal
Version1.1.0
PostgreSQL versions10 · 11 · 12 · 13 · 14 · 15 · 16 · 17 · 18
RepositoryUnspecified
Extension typeStandard
Requires CREATE EXTENSIONYes
Requires preloadNo
TrustedNo
RelocatableNo
Stars36
Latest commit2019-12-18
Catalogue updated2026-08-30

Related extensions

See also

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