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.
- pg12 - partition by column that might have null values Mariel Cherkassky
- Re: pg12 - partition by column that might have null... Laurenz Albe
- Re: pg12 - partition by column that might have ... Mariel Cherkassky
- RE: pg12 - partition by column that might h... Mike Sofen
- Re: pg12 - partition by column that mig... Mariel Cherkassky
- RE: pg12 - partition by column tha... Mike Sofen
- Re: pg12 - partition by column... Mariel Cherkassky
- Re: pg12 - partition by co... Michael Lewis