aboutsummaryrefslogtreecommitdiff
path: root/src/test/regress/sql/interval.sql
diff options
context:
space:
mode:
Diffstat (limited to 'src/test/regress/sql/interval.sql')
-rw-r--r--src/test/regress/sql/interval.sql2
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()