postgres.git / summary / log / commit / refs

commit    ffc703a891e336b9bf4b74112bd4684d1f990fab
Author:   Heikki Linnakangas <heikki.linnakangas@iki.fi>
Date:     Mon Nov 07 15:33:31 2011 +0000
First released in: 9.2.0

    Fix timestamp range subdiff functions, when using float datetimes.


 src/backend/utils/adt/rangetypes.c | 4 ++--
 1 file changed, 2 insertions(+), 2 deletions(-)

diff --git a/src/backend/utils/adt/rangetypes.c b/src/backend/utils/adt/rangetypes.c
index 6327d33f3ae..1ca6627b722 100644
--- a/src/backend/utils/adt/rangetypes.c
+++ b/src/backend/utils/adt/rangetypes.c
@@ -1313,7 +1313,7 @@ tsrange_subdiff(PG_FUNCTION_ARGS)
 #ifdef HAVE_INT64_TIMESTAMP
 	result = ((float8)(v1-v2)) / USECS_PER_SEC;
 #else
-	result = timestamp;
+	result = v1 - v2;
 #endif
 
 	PG_RETURN_FLOAT8(result);
@@ -1329,7 +1329,7 @@ tstzrange_subdiff(PG_FUNCTION_ARGS)
 #ifdef HAVE_INT64_TIMESTAMP
 	result = ((float8)(v1-v2)) / USECS_PER_SEC;
 #else
-	result = timestamp;
+	result = v1 - v2;
 #endif
 
 	PG_RETURN_FLOAT8(result);


[parent: f62be400c0e2]