Horton

Disallow negative strides in date_bin()

John Naylor <john.naylor@postgresql.org>

View on postgr.es
Commit: fc0d9b8c224ff6b84113cefdca1ba9dde879d863
Author: John Naylor <john.naylor@postgresql.org>
Date: 2021-07-28T16:11:33Z
Releases: 14.0 
Disallow negative strides in date_bin()

It's not clear what the semantics of negative strides would be, so throw
an error instead.

Per report from Bauyrzhan Sakhariyev

Reviewed-by: Tom Lane, Michael Paquier
Discussion: https://www.postgresql.org/message-id/CAKpL73vZmLuFVuwF26FJ%2BNk11PVHhAnQRoREFcA03x7znRoFvA%40mail.gmail.com
Backpatch to v14

Files

PathChange+/−
doc/src/sgml/func.sgml modified +2 −6
src/backend/utils/adt/timestamp.c modified +4 −4
src/test/regress/expected/timestamp.out modified +4 −1
src/test/regress/expected/timestamptz.out modified +4 −1
src/test/regress/sql/timestamp.sql modified +3 −0
src/test/regress/sql/timestamptz.sql modified +3 −0

Documentation touched

Discussion