PostgreSQL development exercise

Publish one rule for each effective period.

Check the next NORTH dispatch revision against published periods. Adjacent dates can join; an overlap or uncovered day holds publication.

Receiving window
01 Nov → 01 Dec 2026

NORTH / candidate R62

Candidate overlaps a published revision

Start included [End excluded )

R61 ends on 10 November. R62 can begin on that same date without sharing an effective day.

3Published revisions

1Overlapping published periods

0Uncovered NORTH days

Revision	Route	Rule	Start included	End excluded	Status

SOUTH is evaluated independently. Withdrawn R64 stays in the record history and is excluded from the active-period check.

RV67 receiving manifest

Receive the checked revision before exporting the published record set.

Revision	Route	Rule	Start included	End excluded	Status

The manifest keeps all five revisions, including withdrawn R64, so active coverage and history can be reconciled together.