Applied. Sorry.
> 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 just GOSUB without RETURN.
Content-Description:
> *** ./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 INTO DATETIME_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');
>
-- 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,
Pennsylvania19026
