From: Thomas Lockhart <Thomas.G.Lockhart@jpl.nasa.gov>
Marc G. Fournier <scrappy@hub.org>
From: Thomas Lockhart <Thomas.G.Lockhart@jpl.nasa.gov> Subject: [HACKERS] Money integration patches Here are patches to integrate the money data type. I have included some math and aggregate functions and have made the locale support optional by #ifdef USE_LOCALE bracketing of functions. Modules affected are: builtins.h.patch cash.c.patch cash.h.patch main.c.patch pg_aggregate.h.patch pg_operator.h.patch pg_proc.h.patch pg_type.h.patch I changed the data type to be pass-by-reference rather than by-value to pave the way for a larger internal representation (64-bit ints?). Also, I changed the tabbing of cash.c and cash.h to match most of the other Postgres source code files (4 space indent, 8 spaces == 1 tab). The locale stuff should be tested under another convention (Russian?) but I don't know what the correct results should be so perhaps someone else can give them a try. Will update docs and regression tests in the next few days.
Files
| Path | Change | +/− |
|---|---|---|
| src/backend/main/main.c | modified | +2 −1 |
| src/backend/port/Makefile.in | modified | +2 −1 |
| src/backend/utils/adt/cash.c | modified | +488 −241 |
| src/include/catalog/pg_aggregate.h | modified | +8 −4 |
| src/include/catalog/pg_operator.h | modified | +30 −19 |
| src/include/catalog/pg_proc.h | modified | +20 −2 |
| src/include/catalog/pg_type.h | modified | +10 −19 |
| src/include/utils/builtins.h | modified | +2 −1 |
| src/include/utils/cash.h | modified | +30 −11 |