From 0bc1207aeb3de951bf95a9e9899b1256216d65f5 Mon Sep 17 00:00:00 2001 From: Peter Eisentraut Date: Mon, 23 Jan 2017 14:00:58 -0500 Subject: Fix default minimum value for descending sequences For some reason that is lost in history, a descending sequence would default its minimum value to -2^63+1 (-PG_INT64_MAX) instead of -2^63 (PG_INT64_MIN), even though explicitly specifying a minimum value of -2^63 would work. Fix this inconsistency by using the full range by default. Reported-by: Daniel Verite Reviewed-by: Michael Paquier --- doc/src/sgml/ref/create_sequence.sgml | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) (limited to 'doc/src') diff --git a/doc/src/sgml/ref/create_sequence.sgml b/doc/src/sgml/ref/create_sequence.sgml index 62ae3792267..86ff018c4ba 100644 --- a/doc/src/sgml/ref/create_sequence.sgml +++ b/doc/src/sgml/ref/create_sequence.sgml @@ -133,7 +133,7 @@ SELECT * FROM name; the minimum value a sequence can generate. If this clause is not supplied or is specified, then defaults will be used. The defaults are 1 and - -263-1 for ascending and descending sequences, + -263 for ascending and descending sequences, respectively. -- cgit v1.2.3