Add date_bin function Similar to date_trunc, but allows binning by an arbitrary interval rather than just full units.
Author: John Naylor <john.nay...@enterprisedb.com> Reviewed-by: David Fetter <da...@fetter.org> Reviewed-by: Isaac Morland <isaac.morl...@gmail.com> Reviewed-by: Tom Lane <t...@sss.pgh.pa.us> Reviewed-by: Artur Zakirov <zaar...@gmail.com> Discussion: https://www.postgresql.org/message-id/flat/cacpnzct4buqfrgy6dyjuzs-2apdpccrkrjbmgufwyc1kiax...@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(-)
