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

ECPG: 7.4 and a "to" Variable

From: Lee Kindness <lkindness(at)csl(dot)co(dot)uk>
To: pgsql-interfaces(at)postgresql(dot)org
Cc: Lee Kindness <lkindness(at)csl(dot)co(dot)uk>, pgsql-hackers(at)postgresql(dot)org,Michael Meskes <meskes(at)postgresql(dot)org>
Subject: ECPG: 7.4 and a "to" Variable
Date: 2003-08-01 11:06:07
Message-ID: 16170.18847.811096.853470@kelvin.csl.co.uk (view raw or flat)
Thread:
Lists: pgsql-hackerspgsql-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;
  EXEC SQL 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 basetab LIKE '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.

Responses

pgsql-hackers by date

Next:From: Michael MeskesDate: 2003-08-01 11:33:13
Subject: Re: ECPG: 7.4 and a "to" Variable
Previous:From: D'Arcy J.M. CainDate: 2003-08-01 10:56:35
Subject: Re: python interface

pgsql-interfaces by date

Next:From: Michael MeskesDate: 2003-08-01 11:33:13
Subject: Re: ECPG: 7.4 and a "to" Variable
Previous:From: Christoph HallerDate: 2003-08-01 10:50:49
Subject: Re: load database from ascii files

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