[HACKERS] ECPG: WHENEVER statement with DO CONTINUE action

Поиск
Список
Период
Сортировка
Искать
От
vinayak
Тема
[HACKERS] ECPG: WHENEVER statement with DO CONTINUE action
Дата
Msg-id
148022ca-3318-bbf2-d44e-37aac58658b6@lab.ntt.co.jp
Список
Дерево обсуждения
[HACKERS] ECPG: WHENEVER statement with DO CONTINUE action vinayak <Pokale_Vinayak_q3@lab.ntt.co.jp>
Re: [HACKERS] ECPG: WHENEVER statement with DO CONTINUE action Michael Meskes <meskes@postgresql.org>
Re: [HACKERS] ECPG: WHENEVER statement with DO CONTINUE action Vinayak Pokale <vinpokale@gmail.com>
Re: [HACKERS] ECPG: WHENEVER statement with DO CONTINUE action vinayak <Pokale_Vinayak_q3@lab.ntt.co.jp>
Re: [HACKERS] ECPG: WHENEVER statement with DO CONTINUE action vinayak <Pokale_Vinayak_q3@lab.ntt.co.jp>
Re: [HACKERS] ECPG: WHENEVER statement with DO CONTINUE action Masahiko Sawada <sawada.mshk@gmail.com>
Re: [HACKERS] ECPG: WHENEVER statement with DO CONTINUE action vinayak <Pokale_Vinayak_q3@lab.ntt.co.jp>
Re: [HACKERS] ECPG: WHENEVER statement with DO CONTINUE action vinayak <Pokale_Vinayak_q3@lab.ntt.co.jp>
Re: [HACKERS] ECPG: WHENEVER statement with DO CONTINUE action Masahiko Sawada <sawada.mshk@gmail.com>
Re: [HACKERS] ECPG: WHENEVER statement with DO CONTINUE action vinayak <Pokale_Vinayak_q3@lab.ntt.co.jp>
Re: [HACKERS] ECPG: WHENEVER statement with DO CONTINUE action Masahiko Sawada <sawada.mshk@gmail.com>
Re: [HACKERS] ECPG: WHENEVER statement with DO CONTINUE action vinayak <Pokale_Vinayak_q3@lab.ntt.co.jp>
Re: [HACKERS] ECPG: WHENEVER statement with DO CONTINUE action Masahiko Sawada <sawada.mshk@gmail.com>
Re: [HACKERS] ECPG: WHENEVER statement with DO CONTINUE action vinayak <Pokale_Vinayak_q3@lab.ntt.co.jp>
Re: [HACKERS] ECPG: WHENEVER statement with DO CONTINUE action Michael Meskes <meskes@postgresql.org>
Re: [HACKERS] ECPG: WHENEVER statement with DO CONTINUE action Christian Ullrich <chris@chrullrich.net>
Re: [HACKERS] ECPG: WHENEVER statement with DO CONTINUE action Tom Lane <tgl@sss.pgh.pa.us>
Re: [HACKERS] ECPG: WHENEVER statement with DO CONTINUE action Michael Meskes <meskes@postgresql.org>
Re: [HACKERS] ECPG: WHENEVER statement with DO CONTINUE action Vinayak Pokale <vinpokale@gmail.com>

Hello,

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.

I have tried to implement it. Please check the attached patch.

Please give me feedback.


[1]https://docs.oracle.com/cd/B28359_01/appdev.111/b28427/pc_09err.htm#i12340
Regards,

Vinayak Pokale
NTT Open Source Software Center

В списке pgsql-hackers по дате отправления
От: Antonin Houska
Дата:
Сообщение: Re: [HACKERS] snapbuild woes
От: Konstantin Knizhnik
Дата:
FAQ