NEWS.md

January 6, 2023 · View on GitHub

7.7: Jan 06, 2023

Rewire PostgreSQL 12's new extra_float_digits=1 default internally to 0 to keep nice, short decimal representations.

Import definitions.unit 2.44 from units 2.18 with 36 new units. When upgrading from a previous install, use SELECT unit_load(); to import.
Adjust powers.h to round "1" down by one ULP.

Format time using commonyears + days + hh:mm:ss.sss s.
Avoid using Gs for Gigaseconds, that's actually gauss.
Modify @(unit, text) operator to return text instead of cstring.
Import definitions.units from GNU units 2.17 with 13 new units.
Add π to known units.
Remove bison 2 compat mode, but keep pregenerated files for jessie and trusty.
Support send/receive via the binary protocol.
Support Infinity and NaN.
Add strict comparison operators that error out when dimensions of arguments do not match: << <<= == <<>> >>= >>.
Add range type over units: unitrange.

Add @@ operator: similar to @, but returns the value of the resulting unit as double precision number.
Fix parsing of addition/subtraction in unit values.
Grant SELECT on unit prefixes and units table to public.
Add unit_load() function to load/update the data tables.

Support exponents written using Unicode superscript characters.
Report 22P02/invalid_text_representation on invalid unit input.
Fix crash when unit_reset() runs into an OOM error. Patch by Andreas Seltenreich, thanks!
Change @ operator signature to (unit, text).

Support defining new units at runtime.
Import unit definitions from GNU units.
Add sqrt() and cbrt() functions.
Extension is not relocatable after installation anymore.
Bump extension version to 3.
Bump minimum supported PostgreSQL version to 9.5 so we can use hash_create(HASH_BLOBS).
Bump license to GPL-3+ to match GNU units' license.