enhance SPI to support EXECUTE commands
От
Quan Zongliang
Тема
enhance SPI to support EXECUTE commands
Дата
Msg-id
ff04301f-4e98-2320-2285-60ed0b1b1233@postgresdata.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>
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. Regards, Quan Zongliang
В списке pgsql-hackers по дате отправления