Subject: Re: Implementing Frontend/Backend Protocol TCP/IP
Mime-Version: 1.0 (Apple Message framework v1076)
Content-Type: text/plain; charset=us-ascii; format=flowed; delsp=yes
From: John DeSoi <desoi@pgedit.com>
In-Reply-To: 
 <D960CB61B694CF459DCFB4B0128514C203937FD2@exadv11.host.magwien.gv.at>
Date: Tue, 27 Oct 2009 08:51:39 -0400
Cc: "John R Pierce  *EXTERN*" <pierce@hogranch.com>,
	"Alvaro Herrera" <alvherre@commandprompt.com>,
	"Raimon Fernandez" <coder@montx.com>, <pgsql-general@postgresql.org>
Content-Transfer-Encoding: 7bit
Message-Id: <35DCEEAC-C98D-47A9-8C37-1953CEEB8282@pgedit.com>
References: <92781008-8A70-42CE-A49B-6EE67103FACB@montx.com>
	<FC6CBC8C-A398-4835-B3A3-C16C6F4F62D9@pgedit.com>
	<E084987E-A212-4B70-8CFF-D83AA00629C5@montx.com>
	<C670629A-1E54-4F80-9497-6CCAC1A8BDC0@montx.com>
	<20091026231516.GN8812@alvh.no-ip.org>
	<4AE62E21.7040600@hogranch.com>
	<D960CB61B694CF459DCFB4B0128514C203937FD2@exadv11.host.magwien.gv.at>
To: Albe Laurenz <laurenz.albe@wien.gv.at>


On Oct 27, 2009, at 4:55 AM, Albe Laurenz wrote:

> That's probably not the problem in the original message, but there
> are things you can do with the frontend/backend protocol that libpq
> does not expose: for example, with the extended query protocol you can
> send a "Bind" call that requests that some of the results should be
> returned in text format, others in binary.


Another protocol feature that I don't think is exposed in libpq is the  
ability to limit the maximum number of rows returned by a query. So if  
you are executing end user queries, you don't have to worry about  
processing a massive result set or somehow parsing the query to add a  
limit clause.


John DeSoi, Ph.D.