ECPG: 7.4 and a "to" Variable

Поиск
Список
Период
Сортировка
От Lee Kindness
Тема ECPG: 7.4 and a "to" Variable
Дата
Msg-id 16170.18847.811096.853470@kelvin.csl.co.uk
обсуждение исходный текст
Ответы Re: ECPG: 7.4 and a "to" Variable  (Michael Meskes <meskes@postgresql.org>)
Список pgsql-interfaces
Guys, looking at ecpg from CVS HEAD's 7.4. The following code
fragement:
EXEC SQL INCLUDE sqlca;EXEC SQL WHENEVER SQLERROR call sqlprint;
void lofsdb_GetMinMaxRxStations(int *from, int *to){ EXEC SQL BEGIN DECLARE SECTION; int l_from = 0; int l_to   = 0;
EXECSQL END DECLARE SECTION;
 
 *from = 0; *to   = 0;
 EXEC SQL BEGIN; EXEC SQL SELECT MIN(from_station), MAX(to_station)   INTO :l_from, :l_to   FROM attr_tables   WHERE
basetabLIKE 'attr_rx_%'; if( sqlca.sqlcode == 0 )   {     *from = l_from;     *to   = l_to;   } EXEC SQL COMMIT;}
 

when processed using:
/var/lib/pgsql/74b/bin/ecpg -t -I/var/lib/pgsql/74b/include -o x.c x.pc

results in the following error:
x.pc:4: ERROR: syntax error at or near "to"

However this works ok on 7.3.x and when the "to" variable is renamed
(e.g. to "to_rx"). Obviously TO is an SQL keyword, but it's not being
used within an EXEC SQL definition, so shouldn't break things.

Regards, Lee.


В списке pgsql-interfaces по дате отправления:

Предыдущее
От: Christoph Haller
Дата:
Сообщение: Re: load database from ascii files
Следующее
От: Michael Meskes
Дата:
Сообщение: Re: ECPG: 7.4 and a "to" Variable