It gives me the following error: ERROR: invalid input syntax for type date: "infinity" I thought I could use it anywhere in my sql. I have to add a cast to timestamp in order for this to work. I thought I wouldn't need to use a case. Am I missing something? Thanks in advance. -- Regards, Francisco Figueiredo Jr. Npgsql Lead Developer http://fxjr.blogspot.com http://www.npgsql.org -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general