numeral
numeral datatypes extension
numeral : numeral datatypes extension
Overview
| Attribute | Has Binary | Has Library | Need Load | Has DDL | Relocatable | Trusted |
|---|---|---|---|---|---|---|
| --s-d-r | No | Yes | No | Yes | yes | no |
Packages
| Type | Repo | Version | PG Major Compatibility | Package Pattern | Dependencies |
|---|---|---|---|---|---|
| EXT | MIXED | 1.3 |
18 17 16 15 14 | numeral |
- |
| RPM | PIGSTY | 1.3 |
18 17 16 15 14 | postgresql-numeral_$v |
- |
| DEB | PGDG | 1.3 |
18 17 16 15 14 | postgresql-$v-numeral |
- |
| Linux / PG | PG18 | PG17 | PG16 | PG15 | PG14 |
|---|---|---|---|---|---|
| el8.x86_64 | PIGSTY 1.3 | PIGSTY 1.3 | PIGSTY 1.3 | PIGSTY 1.3 | PIGSTY 1.3 |
| el8.aarch64 | PIGSTY 1.3 | PIGSTY 1.3 | PIGSTY 1.3 | PIGSTY 1.3 | PIGSTY 1.3 |
| el9.x86_64 | PIGSTY 1.3 | PIGSTY 1.3 | PIGSTY 1.3 | PIGSTY 1.3 | PIGSTY 1.3 |
| el9.aarch64 | PIGSTY 1.3 | PIGSTY 1.3 | PIGSTY 1.3 | PIGSTY 1.3 | PIGSTY 1.3 |
| el10.x86_64 | PIGSTY 1.3 | PIGSTY 1.3 | PIGSTY 1.3 | PIGSTY 1.3 | PIGSTY 1.3 |
| el10.aarch64 | PIGSTY 1.3 | PIGSTY 1.3 | PIGSTY 1.3 | PIGSTY 1.3 | PIGSTY 1.3 |
| d12.x86_64 | PGDG 1.3 | PGDG 1.3 | PGDG 1.3 | PGDG 1.3 | PGDG 1.3 |
| d12.aarch64 | PGDG 1.3 | PGDG 1.3 | PGDG 1.3 | PGDG 1.3 | PGDG 1.3 |
| d13.x86_64 | PGDG 1.3 | PGDG 1.3 | PGDG 1.3 | PGDG 1.3 | PGDG 1.3 |
| d13.aarch64 | PGDG 1.3 | PGDG 1.3 | PGDG 1.3 | PGDG 1.3 | PGDG 1.3 |
| u22.x86_64 | PGDG 1.3 | PGDG 1.3 | PGDG 1.3 | PGDG 1.3 | PGDG 1.3 |
| u22.aarch64 | PGDG 1.3 | PGDG 1.3 | PGDG 1.3 | PGDG 1.3 | PGDG 1.3 |
| u24.x86_64 | PGDG 1.3 | PGDG 1.3 | PGDG 1.3 | PGDG 1.3 | PGDG 1.3 |
| u24.aarch64 | PGDG 1.3 | PGDG 1.3 | PGDG 1.3 | PGDG 1.3 | PGDG 1.3 |
| u26.x86_64 | PGDG 1.3 | PGDG 1.3 | PGDG 1.3 | PGDG 1.3 | PGDG 1.3 |
| u26.aarch64 | PGDG 1.3 | PGDG 1.3 | PGDG 1.3 | PGDG 1.3 | PGDG 1.3 |
Source
github.com/df7cb/postgresql-numeral
postgresql-numeral-1.3.tar.gz
Install
Make sure PGDG and PIGSTY repo available:
Install this extension with pig:
Create this extension with:
Usage
The numeral extension provides three custom numeric data types that use textual numerals instead of digits.
Data Types
numeral: English numerals using short scale (10^9 = billion)zahl: German numerals using long scale (10^9 = Milliarde)roman: Roman numerals
All three are internally binary-compatible with bigint and implicitly cast to it.
Examples
Operators
Standard arithmetic operators (+, -, *, /) work through the implicit bigint cast. All existing bigint operators and functions are available.