diff options
Diffstat (limited to 'src/test/regress/sql/interval.sql')
-rw-r--r-- | src/test/regress/sql/interval.sql | 2 |
1 files changed, 2 insertions, 0 deletions
diff --git a/src/test/regress/sql/interval.sql b/src/test/regress/sql/interval.sql index f1da4c29117..7cee2864def 100644 --- a/src/test/regress/sql/interval.sql +++ b/src/test/regress/sql/interval.sql @@ -108,6 +108,8 @@ select avg(f1) from interval_tbl; -- test long interval input select '4 millenniums 5 centuries 4 decades 1 year 4 months 4 days 17 minutes 31 seconds'::interval; +-- test long interval output +select '100000000y 10mon -1000000000d -1000000000h -10min -10.000001s ago'::interval; -- test justify_hours() and justify_days() |