News for hackers. Stuff that matters.
Re:Postgres 15 improves UNIQUE and NULL by Avamander on Monday July 11, 2022 @05:18AM (#32053901)
A boolean column?
Re:Postgres 15 improves UNIQUE and NULL by RedShift1 on Monday July 11, 2022 @05:20AM (#32053912)
It keeps track of _when_, so timestamp.
Re:Postgres 15 improves UNIQUE and NULL by konha on Monday July 11, 2022 @05:38AM (#32054023)
If you care about ‘when’ you probably also care about resubmissions. Or metadata like the supplier’s response. Or who approved the submission etc. A separate table seems like a good solution.
Re:Postgres 15 improves UNIQUE and NULL by vosper on Monday July 11, 2022 @05:38AM (#32054020)
What’s the null-replacing value in a timestamp field?