I see there's still the command:
SET QUERY_LIMIT (even in the docs)
but it doesn't work.
prova=> select * from test limit 1;num|flt8
----+----
1.00| 1
(1 row)
prova=>
prova=> set query_limit = '1';
SET VARIABLE
prova=> select * from test; num| flt8
-----+-----1.00| 12.34|2.343
-3.00| -3
(3 rows)
prova=> show query_limit;
NOTICE: query limit is 1
SHOW VARIABLE
--
______________________________________________________________
PostgreSQL 6.5.0 on i586-pc-linux-gnu, compiled by gcc 2.7.2.3
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
Jose'