execute command tag including affected rows count - Mailing list pgsql-hackers

From Kris Jurka
Subject execute command tag including affected rows count
Date
Msg-id Pine.BSO.4.56.0403211119010.113@leary.csoft.net
Whole thread Raw
Responses Re: execute command tag including affected rows count
List pgsql-hackers
Would it be possible to have the command completion tag for EXECUTE return
the affected row count?  The JDBC API says you should be able to get the
affected row count for any statement and I'm working on integrating a
patch that transforms regular statements to server side prepared
statements, and I'm stuck on this issue.

CREATE TABLE t (a int);
INSERT INTO t VALUES (1);
INSERT INTO t VALUES (2);
PREPARE mystatement AS DELETE FROM t;
EXECUTE mystatement;

would ideally return "EXECUTE 2"

Kris Jurka



pgsql-hackers by date:

Previous
From: Sailesh Krishnamurthy
Date:
Subject: Re: [pgsql-hackers-win32] Sync vs. fsync during
Next
From: "Arthur Ward"
Date:
Subject: Re: Unbalanced Btree Indices ...