Thread

Re: [SQL] MINUS and slow 'not in'

Herouth Maoz <herouth@oumail.openu.ac.il> — 1998-11-24T15:08:28Z

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.

Herouth

--
Herouth Maoz, Internet developer.
Open University of Israel - Telem project
http://telem.openu.ac.il/~herutma