Re: Fetch zero result rows when executing a query?

From: Marko Tiikkaja <marko(at)joh(dot)to>
To: "Stephen R(dot) van den Berg" <srb(at)cuci(dot)nl>, Andres Freund <andres(at)2ndquadrant(dot)com>
Cc: Shay Rojansky <roji(at)roji(dot)org>, pgsql-hackers(at)postgresql(dot)org
Subject: Re: Fetch zero result rows when executing a query?
Date: 2015-02-04 11:25:04
Message-ID: 54D20190.7010104@joh.to
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On 2/4/15 12:17 PM, 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 don't believe so. If this is not about optimization, why can't the
driver just ignore the rows from the server?

.m

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Andres Freund 2015-02-04 11:27:32 Re: Fetch zero result rows when executing a query?
Previous Message Marko Tiikkaja 2015-02-04 11:23:51 Re: Fetch zero result rows when executing a query?