From cfa6999d3b1bdcaa058c90392057a044b0f067e8 Mon Sep 17 00:00:00 2001 From: Tom Lane Date: Tue, 15 Jul 2003 19:19:56 +0000 Subject: Cause SHOW DATESTYLE to produce a string that will be accepted by SET DATESTYLE, for instance 'SQL, European' instead of 'SQL with European conventions'. Per gripe a month or two back from Barry Lind. --- .../expected/horology-no-DST-before-1970.out | 30 +++++++++++----------- .../regress/expected/horology-solaris-1947.out | 30 +++++++++++----------- src/test/regress/expected/horology.out | 30 +++++++++++----------- 3 files changed, 45 insertions(+), 45 deletions(-) (limited to 'src/test') 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 a5edd6103f1..1ad38e34861 100644 --- a/src/test/regress/expected/horology-no-DST-before-1970.out +++ b/src/test/regress/expected/horology-no-DST-before-1970.out @@ -2385,9 +2385,9 @@ DROP TABLE TEMP_TIMESTAMP; -- SET DateStyle TO 'US,Postgres'; SHOW DateStyle; - DateStyle --------------------------------------------- - Postgres with US (NonEuropean) conventions + DateStyle +-------------- + Postgres, US (1 row) SELECT '' AS "64", d1 AS us_postgres FROM TIMESTAMP_TBL; @@ -2555,9 +2555,9 @@ SELECT '' AS seven, f1 AS us_iso FROM ABSTIME_TBL; SET DateStyle TO 'US,SQL'; SHOW DateStyle; - DateStyle ---------------------------------------- - SQL with US (NonEuropean) conventions + DateStyle +----------- + SQL, US (1 row) SELECT '' AS "64", d1 AS us_sql FROM TIMESTAMP_TBL; @@ -2643,9 +2643,9 @@ SELECT '' AS seven, f1 AS us_sql FROM ABSTIME_TBL; SET DateStyle TO 'European,Postgres'; SHOW DateStyle; - DateStyle ------------------------------------- - Postgres with European conventions + DateStyle +-------------------- + Postgres, European (1 row) INSERT INTO TIMESTAMP_TBL VALUES('13/06/1957'); @@ -2739,9 +2739,9 @@ SELECT '' AS seven, f1 AS european_postgres FROM ABSTIME_TBL; SET DateStyle TO 'European,ISO'; SHOW DateStyle; - DateStyle -------------------------------- - ISO with European conventions + DateStyle +--------------- + ISO, European (1 row) SELECT '' AS "65", d1 AS european_iso FROM TIMESTAMP_TBL; @@ -2828,9 +2828,9 @@ SELECT '' AS seven, f1 AS european_iso FROM ABSTIME_TBL; SET DateStyle TO 'European,SQL'; SHOW DateStyle; - DateStyle -------------------------------- - SQL with European conventions + DateStyle +--------------- + SQL, European (1 row) SELECT '' AS "65", d1 AS european_sql FROM TIMESTAMP_TBL; diff --git a/src/test/regress/expected/horology-solaris-1947.out b/src/test/regress/expected/horology-solaris-1947.out index ea64e96beed..31619de8fd9 100644 --- a/src/test/regress/expected/horology-solaris-1947.out +++ b/src/test/regress/expected/horology-solaris-1947.out @@ -2385,9 +2385,9 @@ DROP TABLE TEMP_TIMESTAMP; -- SET DateStyle TO 'US,Postgres'; SHOW DateStyle; - DateStyle --------------------------------------------- - Postgres with US (NonEuropean) conventions + DateStyle +-------------- + Postgres, US (1 row) SELECT '' AS "64", d1 AS us_postgres FROM TIMESTAMP_TBL; @@ -2555,9 +2555,9 @@ SELECT '' AS seven, f1 AS us_iso FROM ABSTIME_TBL; SET DateStyle TO 'US,SQL'; SHOW DateStyle; - DateStyle ---------------------------------------- - SQL with US (NonEuropean) conventions + DateStyle +----------- + SQL, US (1 row) SELECT '' AS "64", d1 AS us_sql FROM TIMESTAMP_TBL; @@ -2643,9 +2643,9 @@ SELECT '' AS seven, f1 AS us_sql FROM ABSTIME_TBL; SET DateStyle TO 'European,Postgres'; SHOW DateStyle; - DateStyle ------------------------------------- - Postgres with European conventions + DateStyle +-------------------- + Postgres, European (1 row) INSERT INTO TIMESTAMP_TBL VALUES('13/06/1957'); @@ -2739,9 +2739,9 @@ SELECT '' AS seven, f1 AS european_postgres FROM ABSTIME_TBL; SET DateStyle TO 'European,ISO'; SHOW DateStyle; - DateStyle -------------------------------- - ISO with European conventions + DateStyle +--------------- + ISO, European (1 row) SELECT '' AS "65", d1 AS european_iso FROM TIMESTAMP_TBL; @@ -2828,9 +2828,9 @@ SELECT '' AS seven, f1 AS european_iso FROM ABSTIME_TBL; SET DateStyle TO 'European,SQL'; SHOW DateStyle; - DateStyle -------------------------------- - SQL with European conventions + DateStyle +--------------- + SQL, European (1 row) SELECT '' AS "65", d1 AS european_sql FROM TIMESTAMP_TBL; diff --git a/src/test/regress/expected/horology.out b/src/test/regress/expected/horology.out index 084f9fe2a64..174dc9cdc0d 100644 --- a/src/test/regress/expected/horology.out +++ b/src/test/regress/expected/horology.out @@ -2385,9 +2385,9 @@ DROP TABLE TEMP_TIMESTAMP; -- SET DateStyle TO 'US,Postgres'; SHOW DateStyle; - DateStyle --------------------------------------------- - Postgres with US (NonEuropean) conventions + DateStyle +-------------- + Postgres, US (1 row) SELECT '' AS "64", d1 AS us_postgres FROM TIMESTAMP_TBL; @@ -2555,9 +2555,9 @@ SELECT '' AS seven, f1 AS us_iso FROM ABSTIME_TBL; SET DateStyle TO 'US,SQL'; SHOW DateStyle; - DateStyle ---------------------------------------- - SQL with US (NonEuropean) conventions + DateStyle +----------- + SQL, US (1 row) SELECT '' AS "64", d1 AS us_sql FROM TIMESTAMP_TBL; @@ -2643,9 +2643,9 @@ SELECT '' AS seven, f1 AS us_sql FROM ABSTIME_TBL; SET DateStyle TO 'European,Postgres'; SHOW DateStyle; - DateStyle ------------------------------------- - Postgres with European conventions + DateStyle +-------------------- + Postgres, European (1 row) INSERT INTO TIMESTAMP_TBL VALUES('13/06/1957'); @@ -2739,9 +2739,9 @@ SELECT '' AS seven, f1 AS european_postgres FROM ABSTIME_TBL; SET DateStyle TO 'European,ISO'; SHOW DateStyle; - DateStyle -------------------------------- - ISO with European conventions + DateStyle +--------------- + ISO, European (1 row) SELECT '' AS "65", d1 AS european_iso FROM TIMESTAMP_TBL; @@ -2828,9 +2828,9 @@ SELECT '' AS seven, f1 AS european_iso FROM ABSTIME_TBL; SET DateStyle TO 'European,SQL'; SHOW DateStyle; - DateStyle -------------------------------- - SQL with European conventions + DateStyle +--------------- + SQL, European (1 row) SELECT '' AS "65", d1 AS european_sql FROM TIMESTAMP_TBL; -- cgit v1.2.3