arkhipov / temporal_tables

Temporal Tables PostgreSQL Extension
BSD 2-Clause "Simplified" License
937 stars 47 forks source link

Update time: #40

Open KES777 opened 6 years ago

KES777 commented 6 years ago

https://github.com/arkhipov/temporal_tables/#update-conflicts-and-time-adjustment

name | department | salary | sys_period
-- | -- | -- | --
Lenina Crowne | Hatchery and Conditioning Centre | 7000 | [T2, T1)

It seems here you should use: statement_timestamp()

thus the updated row will look like:

name | department | salary | sys_period
-- | -- | -- | --
Lenina Crowne | Hatchery and Conditioning Centre | 7000 | [T2, **T4**)