Horton

Add date_bin function

Peter Eisentraut <peter@eisentraut.org>

View on postgr.es
Commit: 49ab61f0bdc93984a8d36b602f6f2a15f09ebcc7
Author: Peter Eisentraut <peter@eisentraut.org>
Date: 2021-03-24T15:18:24Z
Releases: 14.0 
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: https://www.postgresql.org/message-id/flat/CACPNZCt4buQFRgy6DyjuZS-2aPDpccRkrJBmgUfwYc1KiaXYxg@mail.gmail.com

Files

PathChange+/−
doc/src/sgml/func.sgml modified +50 −0
src/backend/utils/adt/timestamp.c modified +74 −0
src/include/catalog/catversion.h modified +1 −1
src/include/catalog/pg_proc.dat modified +11 −0
src/test/regress/expected/timestamp.out modified +96 −0
src/test/regress/expected/timestamptz.out modified +66 −0
src/test/regress/sql/timestamp.sql modified +62 −0
src/test/regress/sql/timestamptz.sql modified +42 −0

Documentation touched

Discussion