Re: pg12 - partition by column that might have null values
Mariel Cherkassky <[email protected]> Wed, 2 Oct 2019 10:37:11 +0300
| Newsgroups | gmane.comp.db.postgresql.performance |
|---|---|
| Message-ID | <CA+t6e1kGq1Ja-hW88gG7CkGSJBEiCrGrWZc7uOqy3U6Do-G2QA@mail.gmail.com> |
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.