Re: Default "maximum rows to retrieve" setting

Поиск
Список
Период
Сортировка
От Dave Page
Тема Re: Default "maximum rows to retrieve" setting
Дата
Msg-id 45FF9ADB.4030500@postgresql.org
обсуждение исходный текст
Ответ на Re: Default "maximum rows to retrieve" setting  (John DeSoi <desoi@pgedit.com>)
Список 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.


В списке pgadmin-support по дате отправления:

Предыдущее
От: John DeSoi
Дата:
Сообщение: Re: Default "maximum rows to retrieve" setting
Следующее
От: jiniusatwork-postgresql@yahoo.com
Дата:
Сообщение: pgadmin binary for Solaris?