electric-sql / electric-sql/electric
Feature request: Support PG "Row Constructor Comparison" for cursor based pagination
Open
feature request
triage
- Dominant language
- TypeScript
- Stars
- 10.4k
- Forks
- 375
- Avg merge
- 3d 1h
- Merged PRs (30d)
- 18
Description
**Is your feature request related to a problem? Please describe.**
Would be great to support row constructor comparison in order to be able to do cursor based pagination in a cleaner way.
Docs here: https://www.postgresql.org/docs/current/functions-comparisons.html#ROW-WISE-COMPARISON
**Describe the solution you'd like**
`WHERE (id, title) > ('a', 'a')` should be supported.
**Additional context**
It's still possible to achieve cursor pagination with a more complex where, but supporting this feature would simplify things a lot.
On version 1.6.9
Contributor guide
Assessment
This issue has not been assessed yet.