diff options
Diffstat (limited to 'src')
| -rw-r--r-- | src/test/regress/expected/horology.out | 30 |
1 files changed, 25 insertions, 5 deletions
diff --git a/src/test/regress/expected/horology.out b/src/test/regress/expected/horology.out index 4315019210d..ab496c38740 100644 --- a/src/test/regress/expected/horology.out +++ b/src/test/regress/expected/horology.out @@ -2341,7 +2341,11 @@ DROP TABLE TEMP_TIMESTAMP; -- SET DateStyle TO 'US,Postgres'; SHOW DateStyle; -INFO: DateStyle is Postgres with US (NonEuropean) conventions + datestyle +-------------------------------------------- + Postgres with US (NonEuropean) conventions +(1 row) + SELECT '' AS "64", d1 AS us_postgres FROM TIMESTAMP_TBL; 64 | us_postgres ----+----------------------------- @@ -2507,7 +2511,11 @@ SELECT '' AS seven, f1 AS us_iso FROM ABSTIME_TBL; SET DateStyle TO 'US,SQL'; SHOW DateStyle; -INFO: DateStyle is SQL with US (NonEuropean) conventions + datestyle +--------------------------------------- + SQL with US (NonEuropean) conventions +(1 row) + SELECT '' AS "64", d1 AS us_sql FROM TIMESTAMP_TBL; 64 | us_sql ----+------------------------ @@ -2591,7 +2599,11 @@ SELECT '' AS seven, f1 AS us_sql FROM ABSTIME_TBL; SET DateStyle TO 'European,Postgres'; SHOW DateStyle; -INFO: DateStyle is Postgres with European conventions + datestyle +------------------------------------ + Postgres with European conventions +(1 row) + INSERT INTO TIMESTAMP_TBL VALUES('13/06/1957'); SELECT count(*) as one FROM TIMESTAMP_TBL WHERE d1 = 'Jun 13 1957'; one @@ -2683,7 +2695,11 @@ SELECT '' AS seven, f1 AS european_postgres FROM ABSTIME_TBL; SET DateStyle TO 'European,ISO'; SHOW DateStyle; -INFO: DateStyle is ISO with European conventions + datestyle +------------------------------- + ISO with European conventions +(1 row) + SELECT '' AS "65", d1 AS european_iso FROM TIMESTAMP_TBL; 65 | european_iso ----+------------------------ @@ -2768,7 +2784,11 @@ SELECT '' AS seven, f1 AS european_iso FROM ABSTIME_TBL; SET DateStyle TO 'European,SQL'; SHOW DateStyle; -INFO: DateStyle is SQL with European conventions + datestyle +------------------------------- + SQL with European conventions +(1 row) + SELECT '' AS "65", d1 AS european_sql FROM TIMESTAMP_TBL; 65 | european_sql ----+------------------------ |