On 1/5/10 9:45 AM, Marko Tiikkaja wrote: > On 2010-01-05 19:21 +0200, Greg Stark wrote: >> with t as (delete from foo returning *) >> select * from t where x=? >> >> applications will almost certainly expect the number to match the >> actual number of rows returned and may well misbehave if they don't. > > I probably wasn't clear about the actual problem in the original post. > The problem only affects INSERT, UDPATE and DELETE where you are > actually counting affected rows (i.e. PQcmdTuples(), not PQntuples()) so > the this example would work as expected.
I don't think there is an "as expected" for this situation; people won't know what to expect. So what do we think is resonable? The current behavior, which reports the total count of rows expected, works for me. --Josh Berkus -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers
