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(at)animaproductions(dot)com

JWebMail WebMail/Java v0.7.6 WWW to Mail Gateway
>From pgsql-general-owner(at)postgresql(dot)org Wed Oct 31 08:32:01 2001
Received: from graal.ensma.fr (graal.ensma.fr [193.55.167.3])
by postgresql.org (8.11.3/8.11.4) with ESMTP id f9VDEGP49242
for <pgsql-general(at)postgresql(dot)org>; Wed, 31 Oct 2001 08:14:16 -0500 (EST)
(envelope-from mimoune(at)ensma(dot)fr)
Received: from Wallace (wallace.ensma.fr [193.55.163.113])
by graal.ensma.fr (8.9.1b+Sun/8.9.1) with SMTP id OAA26233
for <pgsql-general(at)postgresql(dot)org>; Wed, 31 Oct 2001 14:12:14 GMT
Message-ID: <000501c1620d$f4df0d00$71a337c1(at)ensma(dot)fr>
From: "Mourad EL HADJ MIMOUNE" <mimoune(at)ensma(dot)fr>
To: <pgsql-general(at)postgresql(dot)org>
References: <20011030162833(dot)451da024(dot)depesz(at)depesz(dot)pl><LIEBJAJMJFLPHGCPMEBGOEELCEAA(dot)jklcom(at)mindspring(dot)com> <20011031065125(dot)7a9c7929(dot)depesz(at)depesz(dot)pl>
Subject: Re: Differential Backups
Date: Wed, 31 Oct 2001 14:14:22 +0100
MIME-Version: 1.0
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: 7bit
X-Priority: 3
X-MSMail-Priority: Normal
X-Mailer: Microsoft Outlook Express 6.00.2600.0000
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2600.0000
X-Archive-Number: 200110/1184
X-Sequence-Number: 16982

Hi,

I have passed from Postgresql-7.1RC2 to Postgresql-7.1.3 .

I have made a backup of the old data and I have performed a initdb .

I wanted accede to the old data without success. I have used the option -D
/my-old-data of the postmaster to change the data directory but it doesn't
work.

could you give me a solution to make this.

thanks.

Mourad.