Thread: function gurus...

What does fetch 500 in mycursor mean


Cheers

Tony Grant

select *,oid from pga_layout where tablename='' order by oid desc

BEGIN

declare mycursor cursor for select _artiste('WARHOL','Andy') from individu;

fetch 500 in mycursor

END

--
tony@animaproductions.com

JWebMail WebMail/Java v0.7.6 WWW to Mail Gateway

Hi,

It means that mycursor will retrieve up to 500 rows.

Regards,

Antonio Sergio

tony wrote:

>
>What does fetch 500 in mycursor mean
>
>fetch 500 in mycursor
>

On Wed, 2001-10-31 at 18:04, Antonio Sergio de Mello e Souza wrote:

> It means that mycursor will retrieve up to 500 rows.

Great thanks.

Still trying to figure the error messages too.

Tony Grant

--
RedHat Linux on Sony Vaio C1XD/S
http://www.animaproductions.com/linux2.html
Macromedia UltraDev with PostgreSQL
http://www.animaproductions.com/ultra.html