Re: timestamp problem

[Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>]

"Wright, George" <George(dot)Wright(at)infimatic(dot)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