diff options
Diffstat (limited to 'src/test/regress/sql/timetz.sql')
| -rw-r--r-- | src/test/regress/sql/timetz.sql | 7 |
1 files changed, 7 insertions, 0 deletions
diff --git a/src/test/regress/sql/timetz.sql b/src/test/regress/sql/timetz.sql index 7b70f4656c9..b62aa3fe057 100644 --- a/src/test/regress/sql/timetz.sql +++ b/src/test/regress/sql/timetz.sql @@ -45,6 +45,13 @@ SELECT '23:59:60.01 PDT'::timetz; -- not allowed SELECT '24:01:00 PDT'::timetz; -- not allowed SELECT '25:00:00 PDT'::timetz; -- not allowed +-- Test non-error-throwing API +SELECT pg_input_is_valid('12:00:00 PDT', 'timetz'); +SELECT pg_input_is_valid('25:00:00 PDT', 'timetz'); +SELECT pg_input_is_valid('15:36:39 America/New_York', 'timetz'); +SELECT pg_input_error_message('25:00:00 PDT', 'timetz'); +SELECT pg_input_error_message('15:36:39 America/New_York', 'timetz'); + -- -- TIME simple math -- |