pgsql: Add date_bin function

Started by Peter Eisentrautover 5 years ago1 messagescomitters

peter_e@gmx.net

over 5 years ago

Add date_bin function

Similar to date_trunc, but allows binning by an arbitrary interval
rather than just full units.

Author: John Naylor <john.naylor@enterprisedb.com>
Reviewed-by: David Fetter <david@fetter.org>
Reviewed-by: Isaac Morland <isaac.morland@gmail.com>
Reviewed-by: Tom Lane <tgl@sss.pgh.pa.us>
Reviewed-by: Artur Zakirov <zaartur@gmail.com>
Discussion: /messages/by-id/CACPNZCt4buQFRgy6DyjuZS-2aPDpccRkrJBmgUfwYc1KiaXYxg@mail.gmail.com

Branch
------
master

Details
-------
https://git.postgresql.org/pg/commitdiff/49ab61f0bdc93984a8d36b602f6f2a15f09ebcc7

Modified Files
--------------
doc/src/sgml/func.sgml | 50 ++++++++++++++++
src/backend/utils/adt/timestamp.c | 74 ++++++++++++++++++++++++
src/include/catalog/catversion.h | 2 +-
src/include/catalog/pg_proc.dat | 11 ++++
src/test/regress/expected/timestamp.out | 96 +++++++++++++++++++++++++++++++
src/test/regress/expected/timestamptz.out | 66 +++++++++++++++++++++
src/test/regress/sql/timestamp.sql | 62 ++++++++++++++++++++
src/test/regress/sql/timestamptz.sql | 42 ++++++++++++++
8 files changed, 402 insertions(+), 1 deletion(-)