Gavin Sherry <[EMAIL PROTECTED]> writes:
> Shouldn't we be detecting problems with the following (haven't seen
> mention of it):
> template1=# insert into b values('10000000-12-01 23:23:23');
> INSERT 555183 1
> template1=# select * from b;
> ERROR: Unable to format timestamp; internal coding error
Okay, now I get
regression=# select '10000000-12-01 23:23:23'::timestamp;
ERROR: TIMESTAMP out of range '10000000-12-01 23:23:23'
regression=# select '10000000-12-01 23:23:23'::timestamptz;
ERROR: TIMESTAMP WITH TIME ZONE out of range '10000000-12-01 23:23:23'
regards, tom lane
---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to [EMAIL PROTECTED] so that your
message can get through to the mailing list cleanly
