Re: [INTERFACES] ecpg cursors and scope - Mailing list pgsql-interfaces

From Michael Meskes
Subject Re: [INTERFACES] ecpg cursors and scope
Date
Msg-id 19990422175017.A926@gmx.net
Whole thread Raw
In response to Re: [INTERFACES] ecpg cursors and scope  ("Pavel PaJaSoft Janousek" <janousek@fonet.cz>)
Responses Re: [INTERFACES] ecpg cursors and scope
List pgsql-interfaces
On Wed, Apr 21, 1999 at 12:36:59PM +0200, Pavel PaJaSoft Janousek wrote:
>     I think, that principly is correct contructions like this:

No, to do this you need the PREPARE statement.

> ...
>
>     One time I wrote this exec<space><space>sql - and ECPG say parse error
> too, but I forgot, that bad was only this two spaces between 'exec' and
> 'sql'....

Hmm, this is not good.

>     Next, some 'interesting' situations I got when I use exec sql
> whenever... - scope for this is not as the program running, but as the
> source is parsing... - this is ...'-)

That's what the standard says. The whenever statement is a preprocessor
statement.

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.Meskes@gmx.net          | Use PostgreSQL!

pgsql-interfaces by date:

Previous
From: Michael Meskes
Date:
Subject: Re: [INTERFACES] Comment in ECPG - again
Next
From: Margarita Barvinok
Date:
Subject: Re: [INTERFACES] ecpg cursors and scope