enhance SPI to support EXECUTE commands - Mailing list pgsql-hackers

From Quan Zongliang
Subject enhance SPI to support EXECUTE commands
Date
Msg-id ff04301f-4e98-2320-2285-60ed0b1b1233@postgresdata.com
Whole thread Raw
Responses Re: enhance SPI to support EXECUTE commands
Re: enhance SPI to support EXECUTE commands
List pgsql-hackers
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

Attachment

pgsql-hackers by date:

Previous
From: Peter Eisentraut
Date:
Subject: Re: using explicit_bzero
Next
From: Michael Paquier
Date:
Subject: Re: refactoring - share str2*int64 functions