projects / postgresql.git / commit
? search:
summary | shortlog | log | commit | commitdiff | tree
(parent: 1509c6f) | patch
Add date_bin function
authorPeter Eisentraut <peter@eisentraut.org>
Wed, 24 Mar 2021 15:16:14 +0000 (16:16 +0100)
committerPeter Eisentraut <peter@eisentraut.org>
Wed, 24 Mar 2021 15:18:24 +0000 (16:18 +0100)
commit49ab61f0bdc93984a8d36b602f6f2a15f09ebcc7
tree9002c71f5585965e1b3a685fe1edbd07d3e84d8etree
parent1509c6fc29c07d13c9a590fbd6f37c7576f58ba6commit | diff
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
doc/src/sgml/func.sgml diff | blob | blame | history
src/backend/utils/adt/timestamp.c diff | blob | blame | history
src/include/catalog/catversion.h diff | blob | blame | history
src/include/catalog/pg_proc.dat diff | blob | blame | history
src/test/regress/expected/timestamp.out diff | blob | blame | history
src/test/regress/expected/timestamptz.out diff | blob | blame | history
src/test/regress/sql/timestamp.sql diff | blob | blame | history
src/test/regress/sql/timestamptz.sql diff | blob | blame | history
This is the main PostgreSQL git repository.