Re: [BUGS] two minor issues with date time types

2003-08-15 Thread Tom Lane
Stephan Szabo <[EMAIL PROTECTED]> writes: > On Thu, 14 Aug 2003, scott.marlowe wrote: >> insert into test values ('20021131'); >> invalid input syntax for timestamp: "20021131" >> >> SQL92 and 99 say it should be: >> data exception-datetime field overflow > I don't think that's intended to be the

Re: [BUGS] two minor issues with date time types

2003-08-14 Thread Stephan Szabo
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 sh