Hi, > To develop the ECPG application more efficiently and improve > portability, > I would like to suggest one minor improvement "WHENEVER condition DO > CONTINUE" support in ECPG. > Oracle Pro*C supports WHENEVER statement with DO CONTINUE action.[1] > > EXEC SQL WHENEVER SQLERROR CONTINUE; > is not same as > EXEC SQL WHENEVER SQLERROR DO CONTINUE; > > The CONTINUE action instructs the client application to proceed to > the next statement whereas DO CONTINUE action instructs the client > application to emit a C continue statement and the flow of control > return to the beginning of the enclosing loop.
This did actual escape me. Thanks for bringing it to our attention and fixing this missing functionality. > I have tried to implement it. Please check the attached patch. > Please give me feedback. > ... Could you please add a "DO CONTINUE" case to one of the test cases? Or add a new one? We would need a test case IMO. Thanks Michael -- Michael Meskes Michael at Fam-Meskes dot De, Michael at Meskes dot (De|Com|Net|Org) Meskes at (Debian|Postgresql) dot Org Jabber: michael at xmpp dot meskes dot org VfL Borussia! Força Barça! SF 49ers! Use Debian GNU/Linux, PostgreSQL -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers
