On Wed, 30 Jun 1999, Herbert Liechti wrote:
> We upgraded our system from 6.4 to the new 6.5 version. The set query_limit function is not working
> anymore in 6.5.
>
> db => set query_limit to '100';
> SET VARIABLE
> db => select * from table;
>
> statement is returning all records from the table. What's wrong here?
Whereas I'm not sure right now about what's wrong there, you should check
the new documentation of the SELECT command for the LIMIT specifier, as in
select * from table limit 100;
That might help.
--
Peter Eisentraut
PathWay Computing