Re: [HACKERS] Last call?

From: Keith Parks <emkxp01(at)mtcc(dot)demon(dot)co(dot)uk>
To: szybist(at)boxhill(dot)com, Bill(dot)Allie(at)mug(dot)org
Cc: hackers(at)postgresql(dot)org
Subject: Re: [HACKERS] Last call?
Date: 1998-10-25 23:25:14
Message-ID: 199810252325.XAA03485@mtcc.demon.co.uk
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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(dot)Allie(at)mug(dot)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 :-)

Browse pgsql-hackers by date

  From Date Subject
Next Message Taral 1998-10-25 23:29:22 RE: [HACKERS] Re: [DOCS] Last call?
Previous Message Thomas G. Lockhart 1998-10-25 23:02:53 Re: [HACKERS] Re: [DOCS] Last call?