Tom Lane wrote:
> Hiroshi Inoue <Inoue@tpf.co.jp> writes:
> > It seems to me that LIMIT in declare cursor statement is only
> > for optimizer's hint.
>
> I think that would just confuse people.
It could be. However what does LIMIT mean ?
Rows per FETCH ? Probably no.
FETCH forward,backward,forward,backward,.... and suddenly EOF ?
> If we want to have a hint
> that says "optimize for fast start", it ought to be done in another
> way than saying that SELECT ... LIMIT means different things in
> different contexts.
>
Yes I want to give optimizer a hint "return first rows fast".
When Jan implemented LIMIT first,there was an option
"LIMIT ALL" and it was exactly designed for the purpose.
Regards.
Hiroshi Inoue