- Fix printing of values around 1e33 on i386.
- Import definitions.units September 2022 Version 3.15.
- Add R ronna, Q quetta, r ronto, Q quecto, Ri robi, Qi quebi prefixes.
- Fix hash table creation on PostgreSQL 14.
- Packaging updates.
- 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.
- Add rounding function.
- Import definitions.units from GNU units 2.16 with 70 new units.
- 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.
- Support IEC binary prefixes for byte.
- Support United States customary units: in, ft, yd, mi, oz, lb.
- Add variance and stddev aggregates
- Use float8out_internal to format floats on output.
- Initial release