From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
---|---|
To: | "Wright, George" <George(dot)Wright(at)infimatic(dot)com> |
Cc: | "Michael Glaesemann" <grzm(at)seespotcode(dot)net>, pgsql-novice(at)postgresql(dot)org |
Subject: | Re: timestamp problem |
Date: | 2007-10-31 19:51:55 |
Message-ID: | 18865.1193860315@sss.pgh.pa.us |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-novice |
"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
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2007-10-31 21:43:01 | Re: timestamp problem |
Previous Message | niccguard-dev | 2007-10-31 19:34:08 | What data type best used for money |