Re: enhance SPI to support EXECUTE commands

Поиск
Список
Период
Сортировка
Искать
От
Pavel Stehule
Тема
Re: enhance SPI to support EXECUTE commands
Дата
Msg-id
CAFj8pRAVT-eLKfCMr564RYcAsJoQtC22vqn-m5uAFCSFaLyXTg@mail.gmail.com
Ответ на
Список
Дерево обсуждения
enhance SPI to support EXECUTE commands Quan Zongliang <zongliang.quan@postgresdata.com>
Re: enhance SPI to support EXECUTE commands Ahsan Hadi <ahsan.hadi@gmail.com>
Re: enhance SPI to support EXECUTE commands Tomas Vondra <tomas.vondra@2ndquadrant.com>
Re: enhance SPI to support EXECUTE commands Tomas Vondra <tomas.vondra@2ndquadrant.com>
Re: enhance SPI to support EXECUTE commands Pavel Stehule <pavel.stehule@gmail.com>
Re: enhance SPI to support EXECUTE commands Quan Zongliang <zongliang.quan@postgresdata.com>
Re: enhance SPI to support EXECUTE commands Pavel Stehule <pavel.stehule@gmail.com>
Re: enhance SPI to support EXECUTE commands Quan Zongliang <zongliang.quan@postgresdata.com>
Re: enhance SPI to support EXECUTE commands Pavel Stehule <pavel.stehule@gmail.com>
Re: enhance SPI to support EXECUTE commands Quan Zongliang <zongliang.quan@postgresdata.com>
Re: enhance SPI to support EXECUTE commands Pavel Stehule <pavel.stehule@gmail.com>


čt 5. 9. 2019 v 8:39 odesílatel Quan Zongliang <zongliang.quan@postgresdata.com> napsal:
Dear hackers,

I found that such a statement would get 0 in PL/pgSQL.

PREPARE smt_del(int) AS DELETE FROM t1;
EXECUTE 'EXECUTE smt_del(100)';
GET DIAGNOSTICS j = ROW_COUNT;

In fact, this is a problem with SPI, it does not support getting result
of the EXECUTE command. I made a little enhancement. Support for the
number of rows processed when executing INSERT/UPDATE/DELETE statements
dynamically.

Is there some use case for support this feature?

Regards

Pavel


Regards,
Quan Zongliang
В списке pgsql-hackers по дате отправления
От: Fujii Masao
Дата:
От: Etsuro Fujita
Дата:
FAQ