Re-Request mapping of internal variables for stored procedures

[rdlrt]

Re-Request mapping of internal variables for stored procedures

[wolfgangwalther]

I don't think the proposed solution will work for OFFSET, because offset will be applied twice:

• Once inside your function
• Once outside the function by PostgREST directly.

This is not a problem for LIMIT, but with OFFSET it is.

The simplest solution I can think of is to just add my_limit and my_offset arguments to your RPC and then change your query respectively. Those will then only be applied inside your function.

[rdlrt]

Thanks for your reply, but since we need to kinda have the limit/offset (compatible with native postgrest filters as they're exposed as is), the name of URL params themselves need to align.

But thinking for solution on similar lines, I am thinking maybe an extension of that workaround could be to strip off those parameters from URL itself (at reverse proxy before passing to postgrest) and convert limit/offset params to be handled internally - as this can be combed with ACLs to apply on specific endpoints where we do need to optimize the default pagination, accordingly - closing this.