Re: [HACKERS] Last call?
От | Keith Parks |
---|---|
Тема | Re: [HACKERS] Last call? |
Дата | |
Msg-id | 199810252325.XAA03485@mtcc.demon.co.uk обсуждение исходный текст |
Список | pgsql-hackers |
Hi All, Looks fine here, although we did change from BST to GMT last night!! In general PostgreSQL on S/Linux is looking good. I'm running kernel 2.0.35 on a mainly Redhat 4.2 system. The only regression failures are float8 and geometry, due to the usual FP rounding/precision differences. Thanks, Keith. "Billy G. Allie" <Bill.Allie@mug.org> > > "Thomas A. Szybist" wrote: > > > > I just gave today's (Oct 25) snapshot a try on Sparc Linux. > > Looks good except datetime. I'm getting failures due to this type > > of thing: > > > > regression=> SELECT ('today'::datetime ); > > ?column? > > ---------------------------- > > Sun Oct 25 00:00:00 1998 EDT > > (1 row) > > > > regression=> SELECT ('tomorrow'::datetime - '1 day'::timespan); > > ?column? > > ---------------------------- > > Sun Oct 25 01:00:00 1998 EDT > > (1 row) > > > > > > I *think* this may because we're not too far into EST yet. > > Sound good? > > > > This is not a failure. The date 24 hours (1 day) before 'Mon Oct 26 00:00:00 1998 EST' is 'Sun Oct 25 01:00:00 1998 EDT'. You would think it should be 'Sun Oct 25 00:00:00 1998 EST', but thanks to Daylight Savings Time that datetime does not exist :-)
В списке pgsql-hackers по дате отправления: