Skip site navigation (1) Skip section navigation (2)

Peripheral Links

Header And Logo

PostgreSQL
| The world's most advanced open source database.

Site Navigation

Search for
  Advanced Search

Re: Default "maximum rows to retrieve" setting



John DeSoi wrote:
> One of the useful things about the frontend/backend protocol
> (http://www.postgresql.org/docs/8.2/interactive/protocol.html) is that
> it provides a way to set a value for the maximum number of rows to
> return. This avoids the major hassle of trying to analyze the query and
> figure out how to add a limit clause. Unfortunately, I don't recall
> seeing a way set this using libpq or EXECUTE.

No, I don't believe there is a way - and I'm not sure you can prepare a
statement with more than one query in it either; certainly thats the
case if using PQexecParams.

Regards, Dave.



Home | Main Index | Thread Index

Privacy Policy | PostgreSQL Archives hosted by Command Prompt, Inc. | Designed by tinysofa
Copyright © 1996 – 2008 PostgreSQL Global Development Group