Why select 1 where current_date = 'infinity'; doesn't work?

From: "Francisco Figueiredo Jr(dot)" <francisco(at)npgsql(dot)org>
To: pgsql-general(at)postgresql(dot)org
Subject: Why select 1 where current_date = 'infinity'; doesn't work?
Date: 2008-10-14 14:58:15
Message-ID: 438d02260810140758n5bef98cft826ef8ffa9f39b1b@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Kevin Murphy 2008-10-14 14:59:14 Re: Drupal and PostgreSQL - performance issues?
Previous Message Ivan Sergio Borgonovo 2008-10-14 14:28:22 Re: Drupal and PostgreSQL - performance issues?