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

On Tue, Oct 14, 2008 at 12:58 PM, Francisco Figueiredo Jr.
<francisco@npgsql.org> 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