numeral
numeral datatypes extension
Repository
df7cb/postgresql-numeral
https://github.com/df7cb/postgresql-numeral
Source
postgresql-numeral-1.3.tar.gz
postgresql-numeral-1.3.tar.gz
Overview
| ID | Extension | Bin | Lib | Load | Create | Trust | Reloc | Schema |
|---|---|---|---|---|---|---|---|---|
| 3710 | numeral | No | Yes | No | Yes | No | Yes | - |
Version
| Type | Repo | Version | PG Ver | Package | Deps |
|---|---|---|---|---|---|
| EXT | MIXED | 1.3 | 1817161514 | numeral | - |
| RPM | PIGSTY | 1.3 | 1817161514 | postgresql-numeral_$v | - |
| DEB | PGDG | 1.3 | 1817161514 | postgresql-$v-numeral | - |
Build
You can build the RPM packages for numeral using pig build:
Install
You can install numeral directly. First, make sure the PGDG and PIGSTY repositories are added and enabled:
Install the extension using pig or apt/yum/dnf:
Install
pig
dnf
apt
Create Extension:
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.
Was this page helpful?
Thanks—your feedback helps us improve this page.
What got in the way? (optional)