Re: 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: Re: Why select 1 where current_date = 'infinity'; doesn't work?
Date: 2008-10-14 15:04:15
Message-ID: 438d02260810140804h4690b31cyb14ccfa334651919@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message justin 2008-10-14 15:07:04 Re: Chart of Accounts
Previous Message Merlin Moncure 2008-10-14 15:00:12 Re: PL/pgSQL stored procedure returning multiple result sets (SELECTs)?