Postgres Pro
Downloads
Home   >   mailing lists

Re: Fetch zero result rows when executing a query? - Mailing list pgsql-hackers

From Marko Tiikkaja
Subject Re: Fetch zero result rows when executing a query?
Date
Msg-id 54D20190.7010104@joh.to
Whole thread Raw
In response to Re: Fetch zero result rows when executing a query?  ("Stephen R. van den Berg" <srb@cuci.nl>)
Responses Re: Fetch zero result rows when executing a query?  (Andres Freund <andres@2ndquadrant.com>)
List pgsql-hackers
Tree view 
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

pgsql-hackers by date:

Previous
From: Marko Tiikkaja
Date:
Subject: Re: Fetch zero result rows when executing a query?
Next
From: Andres Freund
Date:
Subject: Re: Fetch zero result rows when executing a query?