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

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: francisco(at)npgsql(dot)org
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Why select 1 where current_date = 'infinity'; doesn't work?
Date: 2008-10-14 15:18:04
Message-ID: 29183.1223997484@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

"Francisco Figueiredo Jr." <francisco(at)npgsql(dot)org> writes:
>> ERROR: invalid input syntax for type date: "infinity"
>> I thought I could use it anywhere in my sql.

No, only timestamps support infinity.

We do have a TODO item to allow type date to do that too. It's been asked
for often enough, not sure why it hasn't happened. Seems easy enough,
maybe I'll go do it.

regards, tom lane

In response to

Responses

Browse pgsql-general by date

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