Bruno Wolff III wrote:
>
> Dates cannot have a value of 'infinity'. Either you can store timestamps
> instead of dates or use another column to indicate to indicate the date
> is infinite and have your tests check that column as well as the date
> column.
Ok, so why does postgres let me get away with:
JC=# create table test(a date);
CREATE TABLE
JC=# insert into test values('infinity'::timestamp);
INSERT 1030323 1
If dates cannot hvae a value of infinity why can I insert 'infinity'
into a date field?
Should not postgres throw an error?
Jc