Re:Nanosecond timestamp collisions are common
by btilly on Saturday July 22, 2023 @12:10PM
(#36827424)
Well, that depends on how you manage it. An ORM will find it trivial. Custom SQL, not always so much.
That said, PostgreSQL offers https://www.postgresql.org/docs/current/rowtypes.html which gives you the best of both worlds. A single field which contains 2 fields that can later be extracted. So everywhere you can write a single field for joins, etc. But then when you need it broken out...
That said, PostgreSQL offers https://www.postgresql.org/docs/current/rowtypes.html which gives you the best of both worlds. A single field which contains 2 fields that can later be extracted. So everywhere you can write a single field for joins, etc. But then when you need it broken out...