Postgres Pro
Downloads
Home   >   mailing lists

Re: Why select 1 where current_date = 'infinity'; doesn't work? - Mailing list pgsql-general

From Francisco Figueiredo Jr.
Subject Re: Why select 1 where current_date = 'infinity'; doesn't work?
Date
Msg-id 438d02260810140804h4690b31cyb14ccfa334651919@mail.gmail.com
Whole thread Raw
In response to Why select 1 where current_date = 'infinity'; doesn't work?  ("Francisco Figueiredo Jr." <francisco@npgsql.org>)
Responses Re: Why select 1 where current_date = 'infinity'; doesn't work?  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-general
Tree view 
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

pgsql-general by date:

Previous
From: "Merlin Moncure"
Date:
Subject: Re: PL/pgSQL stored procedure returning multiple result sets (SELECTs)?
Next
From: justin
Date:
Subject: Re: Chart of Accounts