Received: from p3E9C145E.dip0.t-ipconnect.de (root@p3E9C145E.dip0.t-ipconnect.de [62.156.20.94]) by hub.org (8.9.3/8.9.3) with ESMTP id NAA94407 for ; Wed, 5 Jan 2000 13:37:51 -0500 (EST) (envelope-from michael@fam-meskes.de) Received: (from michael@localhost) by tanja.fam-meskes.de (8.9.3/8.9.3/Debian 8.9.3-6) id TAA13160 for pgsql-interfaces@postgreSQL.org; Wed, 5 Jan 2000 19:30:59 +0100 Date: Wed, 5 Jan 2000 19:30:59 +0100 From: Michael Meskes To: pgsql-interfaces@postgreSQL.org Subject: Re: [INTERFACES] ECPG and FETCH Message-ID: <20000105193059.A13149@fam-meskes.de> Mail-Followup-To: pgsql-interfaces@postgreSQL.org References: <3872F1C3.8007B24B@hotgames.com> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii User-Agent: Mutt/1.0i In-Reply-To: <3872F1C3.8007B24B@hotgames.com>; from timk@hotgames.com on Wed, Jan 05, 2000 at 06:24:51PM +1100 On Wed, Jan 05, 2000 at 06:24:51PM +1100, Tim Kane wrote: > First of all, ECPG doesn't seem to recognise the FETCH command at all, > returning with Syntax Error (see below). FETCH IN should work as well as FETCH FROM. I think this is what standard says. I once tried to add FETCH without IN but got some shift/reduce conflicts. I haven't looked into it for quite some time, so maybe I can add a compatibility rule. But don't bet on it. > Secondly, are there any postgres specific Embedded SQL docs around > 'anywhere'? Unfortunately not much. But there are some (5 to be precise) demo files in the source tree. Michael -- Michael Meskes | Go SF 49ers! Th.-Heuss-Str. 61, D-41812 Erkelenz | Go Rhein Fire! Tel.: (+49) 2431/72651 | Use Debian GNU/Linux! Email: Michael@Fam-Meskes.De | Use PostgreSQL!