diff options
author | Heikki Linnakangas <heikki.linnakangas@iki.fi> | 2011-11-07 17:33:31 +0200 |
---|---|---|
committer | Heikki Linnakangas <heikki.linnakangas@iki.fi> | 2011-11-07 17:38:43 +0200 |
commit | ffc703a891e336b9bf4b74112bd4684d1f990fab (patch) | |
tree | fead1247f156a0453046e2e4392e55d0a009ee1d /src | |
parent | f62be400c0e2369d68b4327ced721e47250dc40c (diff) | |
download | postgresql-ffc703a891e336b9bf4b74112bd4684d1f990fab.tar.gz postgresql-ffc703a891e336b9bf4b74112bd4684d1f990fab.zip |
Fix timestamp range subdiff functions, when using float datetimes.
Diffstat (limited to 'src')
-rw-r--r-- | src/backend/utils/adt/rangetypes.c | 4 |
1 files 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); |