diff options
| author | Bruce Momjian <bruce@momjian.us> | 1998-10-14 05:10:12 +0000 |
|---|---|---|
| committer | Bruce Momjian <bruce@momjian.us> | 1998-10-14 05:10:12 +0000 |
| commit | 8cec4cf91b844e8ff3e19a444ddfa750ea4dba11 (patch) | |
| tree | c12d83878cc1ae4588f88c9f830e54e9a5d674dd /doc/src | |
| parent | 39f2ec55d73754382005ecf31407e9990bb88d7a (diff) | |
New QUERY_LIMIT set command.
Diffstat (limited to 'doc/src')
| -rw-r--r-- | doc/src/sgml/ref/set.sgml | 38 |
1 files changed, 38 insertions, 0 deletions
diff --git a/doc/src/sgml/ref/set.sgml b/doc/src/sgml/ref/set.sgml index 64060984d53..87742007efc 100644 --- a/doc/src/sgml/ref/set.sgml +++ b/doc/src/sgml/ref/set.sgml @@ -415,6 +415,44 @@ Equivalent to specifying <command>SET R_PLANS=Off</command>. The frontend may be initialized by setting the PGRPLANS environment variable. +<varlistentry> +<term> +QUERY_LIMIT +</term> +<listitem> +<para> +Sets the number of rows returned by a query. + +<variablelist> +<varlistentry> +<term> +Value +</term> +<listitem> +<para> +Maximum number of rows to return for a query. The default is unlimited. +<varlistentry> +<term> +<replaceable class="parameter">#</replaceable> +</term> +<listitem> +<para> +Sets the maximum number of rows returned by a +query to <replaceable class="parameter">#</replaceable>. +<varlistentry> +<term> +DEFAULT +</term> +<listitem> +<para> +Sets the number of rows returned by a query to unlimited. +</varlistentry> + +<para> + By default, there is no limit to the number of rows + returned by a query. +</variablelist> + </VARLISTENTRY> </VARIABLELIST> </REFSECT2> |