Re: How to specify infinity for intervals ?

Поиск
Список
Период
Сортировка
От Bruce Momjian
Тема Re: How to specify infinity for intervals ?
Дата
Msg-id 200602251634.k1PGYuY25825@candle.pha.pa.us
обсуждение исходный текст
Ответ на Re: How to specify infinity for intervals ?  (Michael Glaesemann <grzm@myrealbox.com>)
Список pgsql-general
OK, added to TODO.

---------------------------------------------------------------------------

Michael Glaesemann wrote:
>
> On Feb 25, 2006, at 12:09 , Bruce Momjian wrote:
>
> > We have this TODO:
> >
> >         o Allow infinite dates just like infinite timestamps
> >
> > Do we need to add intervals to this?
>
> I think to be consistent with the other datetime types, might as
> well. Then one would be able to get an answer to
>
> test=# select 'infinity'::timestamp - current_timestamp;
> ERROR:  cannot subtract infinite timestamps
>
> Michael Glaesemann
> grzm myrealbox com
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 1: if posting/reading through Usenet, please send an appropriate
>        subscribe-nomail command to majordomo@postgresql.org so that your
>        message can get through to the mailing list cleanly
>

--
  Bruce Momjian   http://candle.pha.pa.us
  SRA OSS, Inc.   http://www.sraoss.com

  + If your life is a hard drive, Christ can be your backup. +

В списке pgsql-general по дате отправления:

Предыдущее
От: "Natasha Galkina"
Дата:
Сообщение: rotate records
Следующее
От: Michael Fuhr
Дата:
Сообщение: Re: rotate records