calcite-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Thomas D'Silva" <>
Subject row value constructors for pagination
Date Thu, 29 Aug 2019 01:13:04 GMT
I am looking into the possibility of using row value constructors for
paging through data. The query would be of the form

SELECT * FROM t WHERE (pk1, pk2) > (2,'bar');

which should logically be equivalent to

SELECT * FROM t WHERE pk1 > 2 OR (pk1=2 AND pk2>'bar')

I found a previous thread where this was discussed [1]. Does anyone know
the scope of work it would take to support this feature in Calcite?


  • Unnamed multipart/alternative (inline, None, 0 bytes)
View raw message