RE: A problem presentaion about ECPG, DECLARE STATEMENT - Mailing list pgsql-hackers

From kuroda.hayato@fujitsu.com
Subject RE: A problem presentaion about ECPG, DECLARE STATEMENT
Date
Msg-id TY2PR01MB24436EBE6378D2285DF4CEF8F58E0@TY2PR01MB2443.jpnprd01.prod.outlook.com
Whole thread Raw
In response to Re: A problem presentaion about ECPG, DECLARE STATEMENT  (Peter Eisentraut <peter.eisentraut@2ndquadrant.com>)
List pgsql-hackers
Dear Peter,

I want to complement about another purpose.
This is that declaring an SQL identifier.

In the oracle (and maybe DB2), the following example is not allowed:

...
EXEC SQL DECLARE cursor CURSOR FOR stmt;
                  ^^^^
EXEC SQL PREPARE stmt FOR "SELECT ..."
...

This is caused because these preprocessor cannot recognize stmt as an SQL identifier and
throw an error.
I think DB2 might focus on here, so AT clause is not important for them.
But ECPG can accept these sentences, so it has no meaning for postgres.
That is why I did not mention about it and I focused on the omission of AT clause.

Hayato Kuroda
Fujitsu LIMITED


pgsql-hackers by date:

Previous
From: "kuroda.hayato@fujitsu.com"
Date:
Subject: RE: A problem presentaion about ECPG, DECLARE STATEMENT
Next
From: Fujii Masao
Date:
Subject: Re: [PATCH] Speedup truncates of relation forks