Re: Whatcha' wanta have?????

"Andrew Hamm" <ahamm@mail.com> wrote in message news:c0f04v$16bb62$1@ID-79573.news.uni-berlin.de... > Dorn Bhechsonggram wrote: > > How about a LIMIT clause (LIMIT row_count OFFSET offset) that can be > > used to constrain the number of rows returned by the SELECT statement > > like MySQL, PostgreSQL. > > We have > > select first 100 * from ....> > however there is no offset; noticable by its absence. > > I can see why; it almost makes the engine pull up the first part of the > selection set anyway. I wonder if there is a smart way to do it in Informix. > How do other engines avoid fetching th first 100 records just to get to the > 2nd lot of 100 records? > > Paging through your result-set is a problem for the client - NOT the database.

"Richard Harnden" <richard.harnden@lineone.net> wrote in message news:402ec158$0$52400$65c69314@mercury.nildram.net... > > > Paging through your result-set is a problem for the client - NOT the > database. > While that might be true, if this is provides functionality that would be useful to a whole bunch of customers, we would consider implementing it. We're really trying to be sensitive to customer needs. Thanks for all the comments. M.P. >