pgsql: Add window RANGE support for float4, float8, numeric.

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: pgsql-committers(at)postgresql(dot)org
Subject: pgsql: Add window RANGE support for float4, float8, numeric.
Date: 2018-02-24 18:23:50
Message-ID: E1epeUA-0003CN-F2@gemulon.postgresql.org
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: 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(-)

Browse pgsql-committers by date

  From Date Subject
Next Message Tom Lane 2018-02-24 19:46:41 pgsql: Fix thinko in in_range_float4_float8.
Previous Message Peter Eisentraut 2018-02-24 15:11:30 pgsql: Check error messages in SSL tests