On 2015-02-04 12:17:23 +0100, Stephen R. van den Berg wrote: > Andres Freund wrote: > >On 2015-02-03 12:26:33 +0100, Shay Rojansky wrote: > >> find a way to execute a query but without fetching any rows. The Execute > >> message has a maximum result-row count, but zero is documented to mean > >> "fetch all rows". > > >Is this really a relevant optimization? If the user doesn't want > > I believe he's talking about the network protocol of postgreSQL, not > about query optimisation (as you do).
I actually am not. There's no rows returned by a UPDATE without a RETURNING. So the whole question doesn't really make much sense without RETURNING... And I think it's premature optimization to ignore RETURNING's results in the driver, even if the user doesn't ask for them. Greetings, Andres Freund -- Andres Freund http://www.2ndQuadrant.com/ PostgreSQL Development, 24x7 Support, Training & Services -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers
