pgsql: Add date and timestamp variants of random(min, max).
От | Dean Rasheed |
---|---|
Тема | pgsql: Add date and timestamp variants of random(min, max). |
Дата | |
Msg-id | E1uvuxy-001Fry-2G@gemulon.postgresql.org обсуждение исходный текст |
Список | pgsql-committers |
Add date and timestamp variants of random(min, max). This adds 3 new variants of the random() function: random(min date, max date) returns date random(min timestamp, max timestamp) returns timestamp random(min timestamptz, max timestamptz) returns timestamptz Each returns a random value x in the range min <= x <= max. Author: Damien Clochard <damien@dalibo.info> Reviewed-by: Greg Sabino Mullane <htamfids@gmail.com> Reviewed-by: Dean Rasheed <dean.a.rasheed@gmail.com> Reviewed-by: Vik Fearing <vik@postgresfriends.org> Reviewed-by: Chao Li <li.evan.chao@gmail.com> Discussion: https://postgr.es/m/f524d8cab5914613d9e624d9ce177d3d@dalibo.info Branch ------ master Details ------- https://git.postgresql.org/pg/commitdiff/faf071b553830d39fc583beabcaf56ed65259acc Modified Files -------------- doc/src/sgml/func/func-datetime.sgml | 30 +++++++++ doc/src/sgml/func/func-math.sgml | 3 +- src/backend/utils/adt/pseudorandomfuncs.c | 104 +++++++++++++++++++++++++++--- src/include/catalog/catversion.h | 2 +- src/include/catalog/pg_proc.dat | 12 ++++ src/test/regress/expected/random.out | 87 +++++++++++++++++++++++++ src/test/regress/sql/random.sql | 26 ++++++++ 7 files changed, 254 insertions(+), 10 deletions(-)
В списке pgsql-committers по дате отправления: