Re: Implementing Frontend/Backend Protocol TCP/IP

pg.ddx.io  pgsql-interfaces@postgresql.org mailing list archive  
help / color / mirror / Atom feed

From: John DeSoi <desoi@pgedit.com>
To: Albe Laurenz <laurenz.albe@wien.gv.at>
Cc: John R Pierce *EXTERN* <pierce@hogranch.com>
Cc: Alvaro Herrera <alvherre@commandprompt.com>
Cc: Raimon Fernandez <coder@montx.com>
Cc: pgsql-general@postgresql.org
Subject: Re: Implementing Frontend/Backend Protocol TCP/IP
Date: Tue, 27 Oct 2009 08:51:39 -0400
Message-ID: <35DCEEAC-C98D-47A9-8C37-1953CEEB8282@pgedit.com> (raw)
In-Reply-To: <D960CB61B694CF459DCFB4B0128514C203937FD2@exadv11.host.magwien.gv.at>
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>


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.

view thread (20+ messages)  latest in thread

Message-ID: <35DCEEAC-C98D-47A9-8C37-1953CEEB8282@pgedit.com>
Permalink:  ../35DCEEAC-C98D-47A9-8C37-1953CEEB8282@pgedit.com/
Also on:    postgresql.org/message-id/35DCEEAC-C98D-47A9-8C37-1953CEEB8282@pgedit.com

 ·

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-interfaces@postgresql.org
  Cc: desoi@pgedit.com, laurenz.albe@wien.gv.at, pierce@hogranch.com, alvherre@commandprompt.com, coder@montx.com, pgsql-general@postgresql.org
  Subject: Re: Implementing Frontend/Backend Protocol TCP/IP
  In-Reply-To: <35DCEEAC-C98D-47A9-8C37-1953CEEB8282@pgedit.com>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox