"Francisco Figueiredo Jr." <francisco@xxxxxxxxxx> writes: >> ERROR: invalid input syntax for type date: "infinity" >> I thought I could use it anywhere in my sql. No, only timestamps support infinity. We do have a TODO item to allow type date to do that too. It's been asked for often enough, not sure why it hasn't happened. Seems easy enough, maybe I'll go do it. regards, tom lane -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
