On Thu, 14 Aug 2003, scott.marlowe wrote: > Just two minor issues with timestamps: > > Error message is currently: > > create table test (ts timestamp); > -- insert an illegal date: > insert into test values ('20021131'); > invalid input syntax for timestamp: "20021131" > > SQL92 and 99 say it should be: > > data exception-datetime field overflow > > No big deal, and it doesn't matter to me if it gets changed or not really, > just FYI.
I don't think that's intended to be the textual error message. I believe that's supposed to indicate which SQLSTATE is generated. ---------------------------(end of broadcast)--------------------------- TIP 6: Have you searched our list archives? http://archives.postgresql.org