git.postgresql.org Git - postgresql.git/commit

git projects / postgresql.git / commit

Add date_bin function

author Peter Eisentraut <peter@eisentraut.org>

2021年3月24日 15:16:14 +0000 (16:16 +0100)

committer Peter Eisentraut <peter@eisentraut.org>

2021年3月24日 15:18:24 +0000 (16:18 +0100)

commit 49ab61f0bdc93984a8d36b602f6f2a15f09ebcc7

tree 9002c71f5585965e1b3a685fe1edbd07d3e84d8e tree

parent 1509c6fc29c07d13c9a590fbd6f37c7576f58ba6 commit | 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.

RSS Atom