diff options
| author | Thomas G. Lockhart <lockhart@fourpalms.org> | 2000-03-21 05:59:14 +0000 |
|---|---|---|
| committer | Thomas G. Lockhart <lockhart@fourpalms.org> | 2000-03-21 05:59:14 +0000 |
| commit | 3c7ca8d459cb06596073f0480c030ed44f0ffa25 (patch) | |
| tree | 95f4b1458f060cc1e41afe218ccb08936be65168 | |
| parent | 3ee8f7e207b3459372e13603023a9d84bb800e0b (diff) | |
| download | postgresql-3c7ca8d459cb06596073f0480c030ed44f0ffa25.tar.gz postgresql-3c7ca8d459cb06596073f0480c030ed44f0ffa25.zip | |
Update test for new ORDER BY clause from Tom Lane.
| -rw-r--r-- | src/test/regress/expected/horology.out | 10 |
1 files changed, 5 insertions, 5 deletions
diff --git a/src/test/regress/expected/horology.out b/src/test/regress/expected/horology.out index 251dc6ed409..f026b93fa8d 100644 --- a/src/test/regress/expected/horology.out +++ b/src/test/regress/expected/horology.out @@ -715,7 +715,7 @@ SELECT '' AS four, f1 AS abstime, SELECT '' AS "15", f1 AS timestamp, date( f1) AS date FROM TEMP_TIMESTAMP WHERE f1 <> timestamp 'current' - ORDER BY date; + ORDER BY date, timestamp; 15 | timestamp | date ----+------------------------------+------------ | epoch | 01-01-1970 @@ -726,11 +726,11 @@ SELECT '' AS "15", f1 AS timestamp, date( f1) AS date | Tue Dec 31 17:32:01 1996 PST | 12-31-1996 | Fri Dec 31 17:32:01 1999 PST | 12-31-1999 | Sat Jan 01 17:32:01 2000 PST | 01-01-2000 - | Wed Mar 15 08:14:01 2000 PST | 03-15-2000 - | Wed Mar 15 04:14:02 2000 PST | 03-15-2000 + | Wed Mar 15 01:14:05 2000 PST | 03-15-2000 | Wed Mar 15 02:14:03 2000 PST | 03-15-2000 | Wed Mar 15 03:14:04 2000 PST | 03-15-2000 - | Wed Mar 15 01:14:05 2000 PST | 03-15-2000 + | Wed Mar 15 04:14:02 2000 PST | 03-15-2000 + | Wed Mar 15 08:14:01 2000 PST | 03-15-2000 | Sun Dec 31 17:32:01 2000 PST | 12-31-2000 | Mon Jan 01 17:32:01 2001 PST | 01-01-2001 (15 rows) @@ -760,7 +760,7 @@ SELECT '' AS "15", f1 AS timestamp, abstime( f1) AS abstime SELECT '' AS four, f1 AS abstime, date( f1) AS date FROM ABSTIME_TBL WHERE isfinite(f1) AND f1 <> abstime 'current' - ORDER BY date; + ORDER BY date, abstime; four | abstime | date ------+------------------------------+------------ | Sat May 10 23:59:12 1947 PST | 05-10-1947 |