Received: from clubserv.rp-online.de (clubserv.rp-online.de [149.221.232.11])
	by hub.org (8.9.3/8.9.1) with ESMTP id LAA79121
	for <pgsql-interfaces@postgresql.org>;
	Thu, 22 Apr 1999 11:58:48 -0400 (EDT)
	(envelope-from Michael.Meskes@gmx.net)
Received: from pc63.rp-plus.de (as10-042.rp-plus.de [149.221.236.106])
	by clubserv.rp-online.de (8.9.1a/8.9.1) with ESMTP id RAA13667;
	Thu, 22 Apr 1999 17:57:54 +0200 (METDST)
Received: (from meskes@localhost)
	by pc63.rp-plus.de (8.9.3/8.9.3/Debian/GNU) id RAA00935;
	Thu, 22 Apr 1999 17:50:17 +0200
Date: Thu, 22 Apr 1999 17:50:17 +0200
From: Michael Meskes <meskes@postgresql.org>
To: Pavel PaJaSoft Janousek <janousek@fonet.cz>
Cc: Dave Broudy <shaggy@broudy.net>,
	PgSQL Interfaces <pgsql-interfaces@postgresql.org>
Subject: Re: [INTERFACES] ecpg cursors and scope
Message-ID: <19990422175017.A926@gmx.net>
Mail-Followup-To: Pavel PaJaSoft Janousek <janousek@fonet.cz>,
	Dave Broudy <shaggy@broudy.net>,
	PgSQL Interfaces <pgsql-interfaces@postgresql.org>
References: <00ab01be8be2$e4581480$0200a8c0@server.fonet2.cz>
Mime-Version: 1.0
Content-Type: text/plain; charset=us-ascii
X-Mailer: Mutt 0.95.4i
In-Reply-To: <00ab01be8be2$e4581480$0200a8c0@server.fonet2.cz>;
	from Pavel PaJaSoft Janousek on Wed, Apr 21, 1999 at 12:36:59PM
	+0200

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!