Hello LIMIT has impact on execution plan, so there cannot be variables. Use SRF function and dynamic statements instead.
Regards Pavel On 15/11/2007, Reg Me Please <[EMAIL PROTECTED]> wrote: > In any case, what'd be the benefit for not allowing "variables" as LIMIT and > OFFSET argument? > > -- > Reg me Please > > ---------------------------(end of broadcast)--------------------------- > TIP 9: In versions below 8.0, the planner will ignore your desire to > choose an index scan if your joining column's datatypes do not > match > ---------------------------(end of broadcast)--------------------------- TIP 5: don't forget to increase your free space map settings
