SET QUERY_LIMIT bug report - Mailing list pgsql-hackers

From José Soares
Subject SET QUERY_LIMIT bug report
Date
Msg-id 3767C2A7.B3293817@sferacarta.com
Whole thread Raw
Responses Re: [HACKERS] SET QUERY_LIMIT bug report
List pgsql-hackers
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'




pgsql-hackers by date:

Previous
From: Thomas Lockhart
Date:
Subject: Re: [HACKERS] 6.5.0 - Overflow bug in AVG( )
Next
From: Tom Lane
Date:
Subject: Re: [HACKERS] 6.5.0 - Overflow bug in AVG( )