Thread: BUG #5489: SELECT ... RETURNING INTO ... in ecpg

BUG #5489: SELECT ... RETURNING INTO ... in ecpg

From
"Alexander"
Date:
The following bug has been logged online:

Bug reference:      5489
Logged by:          Alexander
Email address:      goal81@gmail.com
PostgreSQL version: 8.3.11
Operating system:   CentOS 5.4
Description:        SELECT ... RETURNING INTO ... in ecpg
Details:

I've been using PostgreSQL since version 8.2.
As I saw, ecpg preprocessor is unable to handle "SELECT ... RETURNING INTO
... " queries due to the following line in
src/interfaces/ecpg/preproc/preproc.y:

returning_clause:  RETURNING target_list { $$ = ...

Changing this line to:

returning_clause:  RETURNING target_list ecpg_into { $$ = ...

fixes this lack.

Re: BUG #5489: SELECT ... RETURNING INTO ... in ecpg

From
Michael Meskes
Date:
> As I saw, ecpg preprocessor is unable to handle "SELECT ... RETURNING INTO
> ... " queries due to the following line in

I take it you mean INSERT/DELETE/UPDATE and not SELECT right? And yes, those
results weren't moved into C space. I more or less applied your patch to 8.3,
8.4 and 9.0, so the next release will work as expected.

Thanks for spotting this.

Michael

--
Michael Meskes
Michael at Fam-Meskes dot De, Michael at Meskes dot (De|Com|Net|Org)
Michael at BorussiaFan dot De, Meskes at (Debian|Postgresql) dot Org
ICQ 179140304, AIM/Yahoo/Skype michaelmeskes, Jabber meskes@jabber.org
VfL Borussia! Força Barça! Go SF 49ers! Use Debian GNU/Linux, PostgreSQL