Miscellaneous extensions: generate_series, decimal, uuid (§14.7).
Provides three independent extension families:
-
generate_series(START, STOP [, STEP]): virtual table that generates a sequence of integers, commonly used in joins and CTEs.
-
Decimal arithmetic: exact string-based decimal operations that avoid floating-point precision loss. Functions:
decimal,decimal_add,decimal_sub,decimal_mul,decimal_cmp. -
UUID generation:
uuid()generates random UUID v4 strings,uuid_strconverts blob to string,uuid_blobconverts string to blob.