> 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?
You need to patch datetime.sql too. That is required to generate the
proper expected file, which is compared to the out file. Can you supply
the patch?
>
> 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