Unique sort order for postgres pagination
While trying to implement pagination from server side in postgres, i came
across a point that while using limit and offset keywords you have to
provide an ORDER BY clause on a unique column probably the primary key.
In my case i am using the UUID generation for Pkeys so I can't rely on a
sequential order of increasing keys. ORDER BY pkey DESC - might not result
in newer rows on top always. So i resorted to using Created Date column -
timestamp column which should be unique.
But my question comes what if the UI client wants to sort by some other
column? in the event that it might not always be a unique column i resort
to ORDER BY user_column, created_dt DESC so as to maintain predictable
results for postgres pagination.
is this the right approach? i am not sure if i am going the right way.
please advise.
No comments:
Post a Comment