Re: Possible to get LIMIT in an index access method?

2024-04-29 Thread Matthias van de Meent
On Mon, 29 Apr 2024 at 18:17, Chris Cleveland wrote: > > I'm developing an index access method. > > SELECT * > FROM foo > WHERE col <=> constant > ORDER BY col <==> constant > LIMIT 10; > > I'm successfully getting the WHERE and the ORDER BY clauses in my beginscan() > method. Is there any way

Possible to get LIMIT in an index access method?

2024-04-29 Thread Chris Cleveland
I'm developing an index access method. SELECT * FROM foo WHERE col <=> constant ORDER BY col <==> constant LIMIT 10; I'm successfully getting the WHERE and the ORDER BY clauses in my beginscan() method. Is there any way to get the LIMIT (or OFFSET, for that matter)? My access method is designed