Re: Can't figure out how to use now() in default for tsrange column (PG 9.2)

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Can't figure out how to use now() in default for tsrange column (PG 9.2)
Дата
Msg-id 12232.1342492331@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: Can't figure out how to use now() in default for tsrange column (PG 9.2)  (Daniele Varrazzo <daniele.varrazzo@gmail.com>)
Список pgsql-general
Daniele Varrazzo <daniele.varrazzo@gmail.com> writes:
> This suggests me that the PG histogram doesn't count the occurrence
> into bins of the same size over the domain, but instead records the
> boundaries on the domain of bins containing the same amount of data.

Right.  I don't believe the PG planner has any issues with infinite
dates (and if you do find one, we'll do our best to fix it).  But the
point that client-side code might not cope with infinite dates is
very valid, and that's not something that we can undertake to fix
if you run into it.

            regards, tom lane

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

Предыдущее
От: Chris Travers
Дата:
Сообщение: Re: Create stored procedure from C#.net
Следующее
От: Rafal Pietrak
Дата:
Сообщение: Re: Can't figure out how to use now() in default for tsrange column (PG 9.2)