diff options
Diffstat (limited to 'src/test/regress/expected/timetz.out')
| -rw-r--r-- | src/test/regress/expected/timetz.out | 31 |
1 files changed, 31 insertions, 0 deletions
diff --git a/src/test/regress/expected/timetz.out b/src/test/regress/expected/timetz.out index 8942a9b95b..984285663b 100644 --- a/src/test/regress/expected/timetz.out +++ b/src/test/regress/expected/timetz.out @@ -131,6 +131,37 @@ SELECT '25:00:00 PDT'::timetz; -- not allowed ERROR: date/time field value out of range: "25:00:00 PDT" LINE 1: SELECT '25:00:00 PDT'::timetz; ^ +-- Test non-error-throwing API +SELECT pg_input_is_valid('12:00:00 PDT', 'timetz'); + pg_input_is_valid +------------------- + t +(1 row) + +SELECT pg_input_is_valid('25:00:00 PDT', 'timetz'); + pg_input_is_valid +------------------- + f +(1 row) + +SELECT pg_input_is_valid('15:36:39 America/New_York', 'timetz'); + pg_input_is_valid +------------------- + f +(1 row) + +SELECT pg_input_error_message('25:00:00 PDT', 'timetz'); + pg_input_error_message +---------------------------------------------------- + date/time field value out of range: "25:00:00 PDT" +(1 row) + +SELECT pg_input_error_message('15:36:39 America/New_York', 'timetz'); + pg_input_error_message +-------------------------------------------------------------------------------- + invalid input syntax for type time with time zone: "15:36:39 America/New_York" +(1 row) + -- -- TIME simple math -- |