Re: Variable LIMIT and OFFSET in SELECTs - Mailing list pgsql-general

From Pavel Stehule
Subject Re: Variable LIMIT and OFFSET in SELECTs
Date
Msg-id 162867790711150456ga08c48dwe92bb8ea4410da4c@mail.gmail.com
Whole thread Raw
In response to Re: Variable LIMIT and OFFSET in SELECTs  (Reg Me Please <regmeplease@gmail.com>)
List pgsql-general
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 <regmeplease@gmail.com> 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
>

pgsql-general by date:

Previous
From: Reg Me Please
Date:
Subject: Re: Variable LIMIT and OFFSET in SELECTs
Next
From: "Abraham, Danny"
Date:
Subject: Chunk Delete