babelfishpg_money

Overview

special case: this extension only works on wiltondb kernel fork

Version

Build

You can build the RPM / DEB packages for babelfish using pig build:

pig build pkg babelfish         # build RPM / DEB packages

Install

You can install babelfish directly. First, make sure the PGDG and PIGSTY repositories are added and enabled:

pig repo add pgsql -u          # Add repo and update cache

Install the extension using pig or apt/yum/dnf:

pig install babelfish;          # Install for current active PG version

pig ext install -y babelfish -v 18  # PG 18
pig ext install -y babelfish -v 17  # PG 17

dnf install -y babelfish-18       # PG 18
dnf install -y babelfish-17       # PG 17

apt install -y babelfish-18   # PG 18
apt install -y babelfish-17   # PG 17

Create Extension:

CREATE EXTENSION babelfishpg_money;

Usage

babelfishpg_money: SQL Server Money Data Type

The babelfishpg_money extension provides SQL Server-compatible MONEY and SMALLMONEY data type implementations for PostgreSQL as part of the Babelfish project.

Enabling

CREATE EXTENSION babelfishpg_money;

Data Types

• MONEY - 8-byte monetary value ranging from -922,337,203,685,477.5808 to 922,337,203,685,477.5807, with fixed 4 decimal places
• SMALLMONEY - 4-byte monetary value ranging from -214,748.3648 to 214,748.3647, with fixed 4 decimal places

Behavior

The extension implements SQL Server’s monetary arithmetic rules:

• Fixed-point representation with exactly 4 decimal digits
• SQL Server-compatible rounding behavior for monetary calculations
• Proper casting between MONEY and other numeric types
• Arithmetic operations follow SQL Server semantics (e.g., money / money = money, not float)

Notes

• Part of the Babelfish for PostgreSQL project
• Works in conjunction with babelfishpg_common which provides the base type infrastructure
• The PostgreSQL built-in money type has different precision and behavior; this extension provides the SQL Server-compatible variant