Re: Planning of sub partitions

2024-07-05 Thread Matt Hughes
-02'; ) select * from openAndREcentlyRaisedEvents On Fri, Jul 5, 2024 at 11:24 AM Matt Hughes wrote: > I am trying to model a stateful `event` table using partitions. An event > has date_raised (not null) and date_cleared (nullable) columns. An event > is in the "open" state when it has a nul

Planning of sub partitions

2024-07-05 Thread Matt Hughes
I am trying to model a stateful `event` table using partitions. An event has date_raised (not null) and date_cleared (nullable) columns. An event is in the "open" state when it has a null date_cleared; it is in the "closed" state when date_cleared is set. Once date_cleared is set, it won't chang