execute command tag including affected rows count

From: Kris Jurka <books(at)ejurka(dot)com>
To: pgsql-hackers(at)postgresql(dot)org
Subject: execute command tag including affected rows count
Date: 2004-03-21 16:39:23
Message-ID: Pine.BSO.4.56.0403211119010.113@leary.csoft.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Tom Lane 2004-03-21 16:39:49 Re: Unbalanced Btree Indices ...
Previous Message Tom Lane 2004-03-21 16:10:32 Re: Why O_SYNC is faster than fsync on ext3