Re: pg12 - partition by column that might have null values

Поиск
Список
Период
Сортировка
От Mariel Cherkassky
Тема Re: pg12 - partition by column that might have null values
Дата
Msg-id CA+t6e1kGq1Ja-hW88gG7CkGSJBEiCrGrWZc7uOqy3U6Do-G2QA@mail.gmail.com
обсуждение исходный текст
Ответ на Re: pg12 - partition by column that might have null values  (Laurenz Albe <laurenz.albe@cybertec.at>)
Ответы RE: pg12 - partition by column that might have null values
Список pgsql-performance
Whenever I have a new revision of that object, I update the end_time of the latest revision to be now() and I add a new record of that object with end_date null.
The null value is used to find most recent revisions of objects..
Thanks for the suggestion of infinity ! I'll try it.

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

Предыдущее
От: Laurenz Albe
Дата:
Сообщение: Re: pg12 - partition by column that might have null values
Следующее
От: "Mike Sofen"
Дата:
Сообщение: RE: pg12 - partition by column that might have null values