| From: | Dave Page <dpage(at)postgresql(dot)org> |
|---|---|
| To: | John DeSoi <desoi(at)pgedit(dot)com> |
| Cc: | andy(dot)shellam-lists(at)mailnetwork(dot)co(dot)uk, PgAdmin Support Mailing List <pgadmin-support(at)postgresql(dot)org> |
| Subject: | Re: Default "maximum rows to retrieve" setting |
| Date: | 2007-03-20 08:27:07 |
| Message-ID: | 45FF9ADB.4030500@postgresql.org |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgadmin-support |
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.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | jiniusatwork-postgresql | 2007-03-21 14:29:09 | pgadmin binary for Solaris? |
| Previous Message | John DeSoi | 2007-03-20 00:03:44 | Re: Default "maximum rows to retrieve" setting |