diff options
| author | Bruce Momjian | 2006-09-03 03:34:04 +0000 |
|---|---|---|
| committer | Bruce Momjian | 2006-09-03 03:34:04 +0000 |
| commit | fc51c9186a095581beb40d0a46ee13ffb1f99211 (patch) | |
| tree | 86673421343e6b92d965cbdf6c8d86a9430efbf7 /src/test/regress | |
| parent | 5120f88c88517d52d7ab3a80ca2eddd5754180a1 (diff) | |
Properly round months into days and into seconds for interval
multiplication/division queries like select '41 mon 10:00:00'::interval
/ 10 as "pos".
Report from Michael Glaesemann
Diffstat (limited to 'src/test/regress')
| -rw-r--r-- | src/test/regress/expected/interval.out | 2 |
1 files changed, 1 insertions, 1 deletions
diff --git a/src/test/regress/expected/interval.out b/src/test/regress/expected/interval.out index 7a43e90d5db..0adda4a981d 100644 --- a/src/test/regress/expected/interval.out +++ b/src/test/regress/expected/interval.out @@ -218,7 +218,7 @@ SELECT '' AS ten, * FROM INTERVAL_TBL; select avg(f1) from interval_tbl; avg ------------------------------------------------- - @ 4 years 1 mon 9 days 28 hours 18 mins 23 secs + @ 4 years 1 mon 10 days 4 hours 18 mins 23 secs (1 row) -- test long interval input |