Skip site navigation (1) Skip section navigation (2)

function gurus...

From: tony <tony(at)animaproductions(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: function gurus...
Date: 2001-10-31 13:05:16
Message-ID: 6031320.1004533516575.JavaMail.root@localhost (view raw or flat)
Thread:
Lists: pgsql-general
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.



Responses

pgsql-general by date

Next:From: Nikola MilutinovicDate: 2001-10-31 13:37:59
Subject: CP1250 to and from Unicode conversion, how?
Previous:From: hubert depesz lubaczewskiDate: 2001-10-31 05:51:25
Subject: Re: Differential Backups

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group