diff options
| author | Tom Lane <tgl@sss.pgh.pa.us> | 2007-09-16 15:56:32 +0000 |
|---|---|---|
| committer | Tom Lane <tgl@sss.pgh.pa.us> | 2007-09-16 15:56:32 +0000 |
| commit | eb4f4f5b7cb0b95fed42fe44d8b91c21529e25d5 (patch) | |
| tree | a516136fb9d73a971647d5b0cb24499aa850cc8c /src | |
| parent | ee24168d2ca2d96178259ac0625584f60e38537a (diff) | |
| download | postgresql-eb4f4f5b7cb0b95fed42fe44d8b91c21529e25d5.tar.gz postgresql-eb4f4f5b7cb0b95fed42fe44d8b91c21529e25d5.zip | |
Fix overflow in extract(epoch from interval) for intervals exceeding 68 years.
Seems to have been introduced in 8.1 by careless SECS_PER_DAY
search-and-replace.
Diffstat (limited to 'src')
| -rw-r--r-- | src/backend/utils/adt/timestamp.c | 6 |
1 files changed, 3 insertions, 3 deletions
diff --git a/src/backend/utils/adt/timestamp.c b/src/backend/utils/adt/timestamp.c index f94413e3f32..494a9952bf3 100644 --- a/src/backend/utils/adt/timestamp.c +++ b/src/backend/utils/adt/timestamp.c @@ -8,7 +8,7 @@ * * * IDENTIFICATION - * $PostgreSQL: pgsql/src/backend/utils/adt/timestamp.c,v 1.169 2006/11/11 01:14:19 tgl Exp $ + * $PostgreSQL: pgsql/src/backend/utils/adt/timestamp.c,v 1.169.2.1 2007/09/16 15:56:32 tgl Exp $ * *------------------------------------------------------------------------- */ @@ -4190,9 +4190,9 @@ interval_part(PG_FUNCTION_ARGS) #else result = interval->time; #endif - result += (DAYS_PER_YEAR * SECS_PER_DAY) * (interval->month / MONTHS_PER_YEAR); + result += ((double) DAYS_PER_YEAR * SECS_PER_DAY) * (interval->month / MONTHS_PER_YEAR); result += ((double) DAYS_PER_MONTH * SECS_PER_DAY) * (interval->month % MONTHS_PER_YEAR); - result += interval->day * SECS_PER_DAY; + result += ((double) SECS_PER_DAY) * interval->day; } else { |