pgsql: Add window RANGE support for float4, float8, numeric. - Mailing list pgsql-committers

From Tom Lane
Subject pgsql: Add window RANGE support for float4, float8, numeric.
Date
Msg-id E1epeUA-0003CN-F2@gemulon.postgresql.org
Whole thread Raw
List pgsql-committers
Add window RANGE support for float4, float8, numeric.

Commit 0a459cec9 left this for later, but since time's running out,
I went ahead and took care of it.  There are more data types that
somebody might someday want RANGE support for, but this is enough
to satisfy all expectations of the SQL standard, which just says that
"numeric, datetime, and interval" types should have RANGE support.

Branch
------
master

Details
-------
https://git.postgresql.org/pg/commitdiff/8b29e88cdce17705f0b2c43e50219ce1d7d2f603

Modified Files
--------------
src/backend/utils/adt/float.c        |  87 ++++++++++++++++
src/backend/utils/adt/numeric.c      |  75 ++++++++++++++
src/include/catalog/catversion.h     |   2 +-
src/include/catalog/pg_amproc.h      |   3 +
src/include/catalog/pg_proc.h        |   6 ++
src/test/regress/expected/window.out | 185 +++++++++++++++++++++++++++++++++++
src/test/regress/sql/window.sql      |  72 ++++++++++++++
7 files changed, 429 insertions(+), 1 deletion(-)


pgsql-committers by date:

Previous
From: Peter Eisentraut
Date:
Subject: pgsql: Check error messages in SSL tests
Next
From: Tom Lane
Date:
Subject: pgsql: Fix thinko in in_range_float4_float8.