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

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Why select 1 where current_date = 'infinity'; doesn't work?
Дата
Msg-id 29183.1223997484@sss.pgh.pa.us
обсуждение исходный текст
Ответ на 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?
Re: Why select 1 where current_date = 'infinity'; doesn't work?
Список pgsql-general
Дерево обсуждения 
"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 по дате отправления:

Предыдущее
От: justin
Дата:
Сообщение: Re: Chart of Accounts
Следующее
От: "Pavel Stehule"
Дата:
Сообщение: Re: PL/pgSQL stored procedure returning multiple result sets (SELECTs)?