James William Pye <li...@jwp.name> wrote: > Need a special case for the infinities as well? > > postgres=# create table foo (d date); > postgres=# INSERT INTO foo VALUES ('infinity'); > postgres=# COPY foo TO '/Users/jwp/foo.copy' WITH BINARY; > postgres=# COPY foo FROM '/Users/jwp/foo.copy' WITH BINARY; > ERROR: date out of range
Exactly. Patch attached. We have special treatments of infinity in timestamp_recv, but don't have in date_recv. Regards, --- Takahiro Itagaki NTT Open Source Software Center
date_recv_infinity_20100218.patch
Description: Binary data
-- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers