From d062f0f4e91f68b1f55b04691bd92d1efc83dc54 Mon Sep 17 00:00:00 2001 From: Tom Lane Date: Fri, 10 Aug 2001 18:40:53 +0000 Subject: [PATCH] Fix collateral damage from error message cleanup. --- src/test/regress/expected/horology-no-DST-before-1970.out | 8 ++++---- src/test/regress/expected/horology-solaris-1947.out | 8 ++++---- src/test/regress/output/create_function_1.source | 2 +- 3 files changed, 9 insertions(+), 9 deletions(-) diff --git a/src/test/regress/expected/horology-no-DST-before-1970.out b/src/test/regress/expected/horology-no-DST-before-1970.out index f71b6a9821..44548ac813 100644 --- a/src/test/regress/expected/horology-no-DST-before-1970.out +++ b/src/test/regress/expected/horology-no-DST-before-1970.out @@ -43,7 +43,7 @@ SELECT date '1991-02-03' - time '04:05:06' AS "Subtract Time"; (1 row) SELECT date '1991-02-03' - time with time zone '04:05:06 UTC' AS "Subtract Time UTC"; -ERROR: Unable to identify an operator '-' for types 'date' and 'timetz' +ERROR: Unable to identify an operator '-' for types 'date' and 'time with time zone' You will have to retype this query using an explicit cast -- -- timestamp, interval arithmetic @@ -118,9 +118,9 @@ SELECT interval '04:30' - time '01:02' AS "+03:28"; (1 row) SELECT CAST(time with time zone '01:02-08' AS interval) AS "+00:01"; -ERROR: Cannot cast type 'timetz' to 'interval' +ERROR: Cannot cast type 'time with time zone' to 'interval' SELECT CAST(interval '02:03' AS time with time zone) AS "02:03:00-08"; -ERROR: Cannot cast type 'interval' to 'timetz' +ERROR: Cannot cast type 'interval' to 'time with time zone' SELECT time with time zone '01:30-08' - interval '02:01' AS "23:29:00-08"; 23:29:00-08 ------------- @@ -153,7 +153,7 @@ SELECT CAST(date 'today' + time with time zone '03:30' (1 row) SELECT interval '04:30' - time with time zone '01:02' AS "+03:28"; -ERROR: Unable to identify an operator '-' for types 'interval' and 'timetz' +ERROR: Unable to identify an operator '-' for types 'interval' and 'time with time zone' You will have to retype this query using an explicit cast -- We get 100 rows when run in GMT... SELECT t.d1 + i.f1 AS "102" FROM TIMESTAMP_TBL t, INTERVAL_TBL i diff --git a/src/test/regress/expected/horology-solaris-1947.out b/src/test/regress/expected/horology-solaris-1947.out index 99313d4cb4..dd5ff231e0 100644 --- a/src/test/regress/expected/horology-solaris-1947.out +++ b/src/test/regress/expected/horology-solaris-1947.out @@ -43,7 +43,7 @@ SELECT date '1991-02-03' - time '04:05:06' AS "Subtract Time"; (1 row) SELECT date '1991-02-03' - time with time zone '04:05:06 UTC' AS "Subtract Time UTC"; -ERROR: Unable to identify an operator '-' for types 'date' and 'timetz' +ERROR: Unable to identify an operator '-' for types 'date' and 'time with time zone' You will have to retype this query using an explicit cast -- -- timestamp, interval arithmetic @@ -118,9 +118,9 @@ SELECT interval '04:30' - time '01:02' AS "+03:28"; (1 row) SELECT CAST(time with time zone '01:02-08' AS interval) AS "+00:01"; -ERROR: Cannot cast type 'timetz' to 'interval' +ERROR: Cannot cast type 'time with time zone' to 'interval' SELECT CAST(interval '02:03' AS time with time zone) AS "02:03:00-08"; -ERROR: Cannot cast type 'interval' to 'timetz' +ERROR: Cannot cast type 'interval' to 'time with time zone' SELECT time with time zone '01:30-08' - interval '02:01' AS "23:29:00-08"; 23:29:00-08 ------------- @@ -153,7 +153,7 @@ SELECT CAST(date 'today' + time with time zone '03:30' (1 row) SELECT interval '04:30' - time with time zone '01:02' AS "+03:28"; -ERROR: Unable to identify an operator '-' for types 'interval' and 'timetz' +ERROR: Unable to identify an operator '-' for types 'interval' and 'time with time zone' You will have to retype this query using an explicit cast -- We get 100 rows when run in GMT... SELECT t.d1 + i.f1 AS "102" FROM TIMESTAMP_TBL t, INTERVAL_TBL i diff --git a/src/test/regress/output/create_function_1.source b/src/test/regress/output/create_function_1.source index d075a61eb8..92183d18b3 100644 --- a/src/test/regress/output/create_function_1.source +++ b/src/test/regress/output/create_function_1.source @@ -5,7 +5,7 @@ CREATE FUNCTION widget_in(opaque) RETURNS widget AS '@abs_builddir@/regress@DLSUFFIX@' LANGUAGE 'c'; -NOTICE: ProcedureCreate: type 'widget' is not yet defined +NOTICE: ProcedureCreate: type widget is not yet defined CREATE FUNCTION widget_out(opaque) RETURNS opaque AS '@abs_builddir@/regress@DLSUFFIX@' -- 2.40.0