Postgres Pro
Downloads
Home   >   mailing lists

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

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

pgsql-general by date:

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