Hello!
On Sat, 23 Jan 1999, Bruce Momjian wrote:
> > Someone (you, according to the cvs logs) checked in an update to the
> > "expected" file for the datetime regress test, but didn't check in the
> > corresponding update to the test file itself. sql/datetime.sql is
> > still dated 1997 ...
>
> It came from someone, not sure who. Can someone comment? If not, let's
> back it out.
>
> --
> Bruce Momjian | http://www.op.net/~candle
> maillist@candle.pha.pa.us | (610) 853-3000
> + If your life is a hard drive, | 830 Blythe Avenue
> + Christ can be your backup. | Drexel Hill, Pennsylvania 19026
Probably that's me. The patch attached. Is there any problem?
Oleg.
---- Oleg Broytmann http://members.tripod.com/~phd2/ phd2@earthling.net Programmers don't die, they
justGOSUB without RETURN.
*** ./src/test/regress/expected/datetime.out.orig Mon Jan 5 06:35:27 1998
--- ./src/test/regress/expected/datetime.out Wed Jan 6 12:50:50 1999
***************
*** 28,33 ****
--- 28,40 ---- @ 0 (1 row)
+ QUERY: SET DateStyle = 'Postgres,noneuropean';
+ QUERY: SELECT datetime('1994-01-01', '11:00') AS "Jan_01_1994_11am";
+ Jan_01_1994_11am
+ ----------------------------
+ Sat Jan 01 11:00:00 1994 PST
+ (1 row)
+ QUERY: CREATE TABLE DATETIME_TBL( d1 datetime); QUERY: INSERT INTO DATETIME_TBL VALUES ('current'); QUERY: INSERT
INTODATETIME_TBL VALUES ('today');
*** ./src/test/regress/sql/datetime.sql.orig Sat Nov 15 05:55:57 1997
--- ./src/test/regress/sql/datetime.sql Wed Jan 6 12:49:23 1999
***************
*** 10,15 ****
--- 10,18 ---- SELECT ('current'::datetime = 'now'::datetime) as "True"; SELECT ('now'::datetime - 'current'::datetime)
AS"ZeroSecs";
+ SET DateStyle = 'Postgres,noneuropean';
+ SELECT datetime('1994-01-01', '11:00') AS "Jan_01_1994_11am";
+ CREATE TABLE DATETIME_TBL( d1 datetime); INSERT INTO DATETIME_TBL VALUES ('current');