X-Original-To: pgsql-interfaces-postgresql.org@localhost.postgresql.org
Received: from localhost (neptune.hub.org [200.46.204.2])
	by svr1.postgresql.org (Postfix) with ESMTP id E542BD1B44B
	for <pgsql-interfaces-postgresql.org@localhost.postgresql.org>;
	Sat, 27 Dec 2003 14:18:40 +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 37579-06
	for <pgsql-interfaces-postgresql.org@localhost.postgresql.org>;
	Sat, 27 Dec 2003 10:17:54 -0400 (AST)
Received: from moutng.kundenserver.de (moutng.kundenserver.de
	[212.227.126.185])
	by svr1.postgresql.org (Postfix) with ESMTP id B804ED1B462
	for <pgsql-interfaces@postgresql.org>;
	Sat, 27 Dec 2003 10:17:45 -0400 (AST)
Received: from [212.227.126.162] (helo=mrelayng.kundenserver.de)
	by moutng.kundenserver.de with esmtp (Exim 3.35 #1)
	id 1AaFGG-0008Ak-00
	for pgsql-interfaces@postgresql.org; Sat, 27 Dec 2003 15:17:48 +0100
Received: from [80.128.68.67] (helo=FRITZweb)
	by mrelayng.kundenserver.de with asmtp (Exim 3.35 #1)
	id 1AaFGG-0007E0-00
	for pgsql-interfaces@postgresql.org; Sat, 27 Dec 2003 15:17:48 +0100
From: =?iso-8859-1?Q?J=FCrgen_Cappel?= <email@juergen-cappel.de>
To: <pgsql-interfaces@postgresql.org>
Subject: ecpg odd syntax error at array index
Date: Sat, 27 Dec 2003 15:18:45 +0100
Message-ID: <JEEKIPNAKJNCFLMOBKHGMEALDCAA.email@juergen-cappel.de>
MIME-Version: 1.0
Content-Type: text/plain;
	charset="iso-8859-1"
Content-Transfer-Encoding: 8bit
X-Priority: 3 (Normal)
X-MSMail-Priority: Normal
X-Mailer: Microsoft Outlook IMO, Build 9.0.2416 (9.0.2910.0)
Importance: Normal
X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4133.2400
X-Provags-ID: kundenserver.de abuse@kundenserver.de
	auth:18ffa34e0aa20c651c9363a5f5f711d8
X-Virus-Scanned: by amavisd-new at postgresql.org
X-Spam-Status: No, hits=0.8 tagged_above=0.0 required=5.0 tests=BAYES_30,
	MSGID_GOOD_EXCHANGE, RCVD_IN_NJABL, UPPERCASE_25_50
X-Spam-Level: 
X-Archive-Number: 200312/54
X-Sequence-Number: 4663

Hello,

seems odd, but why is the first SELECT a, quote: syntax error at or near "["
while the second one is OK ?  Do spaces really make a difference for ecpg
before an array index ?

myfunction ()
{
    EXEC SQL BEGIN DECLARE SECTION;
    char  chtm[23][19];
    EXEC SQL END DECLARE SECTION;

    EXEC SQL SELECT mycolumn INTO :chtm[ 0] FROM mytable WHERE ...;
    EXEC SQL SELECT mycolumn INTO :chtm[1] FROM mytable WHERE ...;
}

Versions are:

ecpg (PostgreSQL 7.4) 3.0.0
Linux scaleo 2.4.18-4GB #1 Wed Mar 27 13:57:05 UTC 2002 i686 unknown

Jürgen Cappel