select open change scope Open full search

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

Extensions / Data types

pg_fraction

Adds a fraction data type with arithmetic, comparison, aggregate and B-tree operator-class support.

pgext.cloud · Source code · Documentation · Control file

Overview

Packagepg_fraction
Version1.0
RepositoryUnspecified
Extension typeStandard
Requires CREATE EXTENSIONYes
Requires preloadNo
TrustedNo
RelocatableYes
Stars4
Latest commit2018-01-24
Catalogue updated2026-08-30

Related extensions

See also

parray_ginGIN index operator class and partial-match operators for text arrays
pg_secretDefines order-revealing encrypted domains, comparison operators, and a B-tree operator class.
ksjJapanese kanji-numeral integer type with arithmetic, aggregates, casts, comparison, and B-tree indexing
tinyintOne-byte signed integer type with arithmetic, casts, aggregates, and B-tree, hash, and GIN operator classes.
natord_pgNatural-order comparison operators and btree operator class for PostgreSQL text values.
pg_strverscmpNatural-sort comparison functions, text operators, and a btree operator class based on a strverscmp-like order.
rumRUM index access method
pg_s2Adds an S2 CellID type, hierarchy and covering functions, distance helpers, casts, operators, and a B-tree operator class.
json_utilsJSON type helper functions, operators, and a hash operator class for PostgreSQL 9.2+.
device_typeFixed-byte enum-like data type for mobile device types with comparison operators and btree/hash operator classes.