News for hackers. Stuff that matters.

A comment on Features I'd Like in PostgreSQL. Parent comment

Re:Features I'd Like in PostgreSQL by topicseed on Sunday January 29, 2023 @09:35AM (#34568473)
What if two rows use the same prev_playlist_member_id?
[ Parent | on HN ]
Re:Features I'd Like in PostgreSQL by forrest2 on Monday January 30, 2023 @03:27AM (#34577219)
You make that impossible with application logic or constraints. Just like any linked list, you need to update the other pointers

Example constraint would be a unique index for the Playlist member table on the combination of Playlist id and previous Playlist member ID.

[ Parent | on HN ]