X-Original-To: pgsql-interfaces-postgresql.org@localhost.postgresql.org
Received: from localhost (unknown [200.46.204.2])
	by svr1.postgresql.org (Postfix) with ESMTP id E2110D1EDAF
	for <pgsql-interfaces-postgresql.org@localhost.postgresql.org>;
	Mon, 29 Mar 2004 15:15:36 +0000 (GMT)
Received: from svr1.postgresql.org ([200.46.204.71])
	by localhost (neptune.hub.org [200.46.204.2]) (amavisd-new, port 10024)
	with ESMTP id 28653-08
	for <pgsql-interfaces-postgresql.org@localhost.postgresql.org>;
	Mon, 29 Mar 2004 11:15:44 -0400 (AST)
Received: from moutng.kundenserver.de (moutng.kundenserver.de
	[212.227.126.177])
	by svr1.postgresql.org (Postfix) with ESMTP id 5E993D1ED87
	for <pgsql-interfaces@postgresql.org>;
	Mon, 29 Mar 2004 11:15:32 -0400 (AST)
Received: from [212.227.126.207] (helo=mrelayng.kundenserver.de)
	by moutng.kundenserver.de with esmtp (Exim 3.35 #1)
	id 1B7yUF-0006Tx-00; Mon, 29 Mar 2004 17:15:40 +0200
Received: from [80.142.187.25] (helo=fam-meskes.de)
	by mrelayng.kundenserver.de with asmtp (Exim 3.35 #1)
	id 1B7yUF-00007Q-00; Mon, 29 Mar 2004 17:15:40 +0200
Received: from feivel (feivel.fam-meskes.de [172.26.14.14])
	by fam-meskes.de (Postfix) with ESMTP
	id 3A43010EF2C; Mon, 29 Mar 2004 17:15:38 +0200 (CEST)
Received: by feivel (Postfix, from userid 1000)
	id 19A084ACD8; Mon, 29 Mar 2004 17:15:35 +0200 (CEST)
Date: Mon, 29 Mar 2004 17:15:35 +0200
From: Michael Meskes <meskes@postgresql.org>
To: Stergios Zissakis <szis@intranet.gr>
Cc: pgsql-interfaces@postgresql.org
Subject: Re: ECPG mass retrieval?
Message-ID: <20040329151535.GB5929@1>
Mail-Followup-To: Stergios Zissakis <szis@intranet.gr>,
	pgsql-interfaces@postgresql.org
References: <NGBBJHBHDKPNOODGDMMAKELNCGAA.szis@intranet.gr>
Mime-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Disposition: inline
In-Reply-To: <NGBBJHBHDKPNOODGDMMAKELNCGAA.szis@intranet.gr>
User-Agent: Mutt/1.5.5.1+cvs20040105i
X-Provags-ID: kundenserver.de abuse@kundenserver.de
	auth:da5cff6069dd6897c77170232368d0ba
X-Virus-Scanned: by amavisd-new at postgresql.org
X-Archive-Number: 200403/41
X-Sequence-Number: 4820

On Mon, Mar 29, 2004 at 04:13:22PM +0300, Stergios Zissakis wrote:
> It is possible to do bulk retrievals using ECPG?

Yes.

> What alternatives do I have to fetch things in bulk?

Just look into test1.pgc in the source tree to see how it works. Of
course, as already pointed out, you don't have to use fixed-size arrays.
Ecpg can allocate the memory for you.

Michael
-- 
Michael Meskes
Email: Michael at Fam-Meskes dot De
ICQ: 179140304, AIM/Yahoo: michaelmeskes, Jabber: meskes@jabber.org
Go SF 49ers! Go Rhein Fire! Use Debian GNU/Linux! Use PostgreSQL!