On Tue, Oct 14, 2008 at 12:58 PM, Francisco Figueiredo Jr. <francisco@xxxxxxxxxx> wrote: > 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? > Ok, I think I'm missing something... Just after sending this message I noticed the current_timestamp function which works like a charm. Sorry for the noise. -- 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
