Re: timestamp problem

"Wright, George" <George.Wright@infimatic.com> writes:
> I would expect:
> myhost=> select isfinite(timestamp '2007-10-14 00:00:00 BRST');
> to error out just like:

No, this is intentional behavior.  Note the comment in
DetermineTimeZoneOffset:

    /*
     * It's an invalid or ambiguous time due to timezone transition. Prefer
     * the standard-time interpretation.
     */

BTW, isfinite() has got nothing whatever to do with this.  If an error
were to be thrown, it would have to be during timestamp value input.

            regards, tom lane