Posted by Matthew Weier O'Phinney on 04/22/05 17:31

* Jochem Maas <jochem@iamjochem.com> :
> Richard Lynch wrote:
> > On Thu, April 21, 2005 12:23 pm, Warren Vail said:
> >
> > > The only approach left that I could come up with is to transfer the
> > > entire sequence set to your application, and count the rows, perhaps
> > > only displaying the rows you want to show. This is obviously not very
> > > efficient (in fact, with enough rows it may prove impossible because of
> > > memory limitations), but it will produce what appears to be a paged
> > > result.
> >
> > If this is the best answer your database software will let you come up
> > with, it's time to switch databases :-)
> >
> > Fortunately, the databases that don't do "LIMIT" have this nifty thing
>
> I was under the impression that LIMIT was mySQL specific (although its
> quite likely that their use of the keyword and the ubiqitous nature of mySQL
> that other vendors have also adopted it.

Actually, LIMIT is in ANSI SQL.

--
Matthew Weier O'Phinney | WEBSITES:
Webmaster and IT Specialist | http://www.garden.org
National Gardening Association | http://www.kidsgardening.com
802-863-5251 x156 | http://nationalgardenmonth.org
mailto:matthew@garden.org | http://vermontbotanical.org

[Back to original message]