electric-sql / electric-sql/electric

Feature request: Support PG "Row Constructor Comparison" for cursor based pagination

Open
#4,510 0 comments 0 reactions 0 assignees View on GitHub
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

Image

Image

Contributor guide

Open the contributing guide

Assessment

This issue has not been assessed yet.

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.