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

Поиск
Список
Период
Сортировка
От Tom Lane
Тема pgsql: Add window RANGE support for float4, float8, numeric.
Дата
Msg-id E1epeUA-0003CN-F2@gemulon.postgresql.org
обсуждение исходный текст
Список 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 по дате отправления:

Предыдущее
От: Peter Eisentraut
Дата:
Сообщение: pgsql: Check error messages in SSL tests
Следующее
От: Tom Lane
Дата:
Сообщение: pgsql: Fix thinko in in_range_float4_float8.