Add date_bin function Similar to date_trunc, but allows binning by an arbitrary interval rather than just full units.
Author: John Naylor <[email protected]> Reviewed-by: David Fetter <[email protected]> Reviewed-by: Isaac Morland <[email protected]> Reviewed-by: Tom Lane <[email protected]> Reviewed-by: Artur Zakirov <[email protected]> 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(-)
