Re: [SQL] MINUS and slow 'not in' - Mailing list pgsql-sql

>
> At 16:57 +0200 on 24/11/98, pierre@desertmoon.com wrote:
>
>
> > I've tried...
> >
> > insert into B
> > fetch 2000 from fubar;
> >
> > Which just gives a parser error. There is very little documentation on
> > cursors written up that I can find. I've even searched the email archives.
> > Ideas?
>
> Well, this usage of a cursor is not supported, as far as I know. However,
> if you have 6.4 (do you?), you can use SET QUERY_LIMIT to limit the number
> of rows fetched from the SELECT. I suppose you can set it back after you do
> the INSERT.
>

Yeah I've got 6.4. I tried:

set query_limit to 2000;

and got:

ERROR:  parser: parse error at or near "2000"

Ideas?

-=pierre