Re: [SQL-Ledger-users] LARGE INVENTORY

[Thomas S. <ps...@on...>]

Well what do you know, three way to do it!

If the offset works for both Postgres and MySQl then maybe that's the
best way to go.

-- 
Thomas Sawyer
ps...@on... - email
(303) 285-3487 x1594 - voicemail/fax



---- Matt Benjamin <ma...@li...> wrote:
> 
> Seems like this works for MySQL or Postgres.  With Oracle, you can
> do
> things with ROWNUM to similar effect.
> 
> Matt
> 
> 
> Matt Benjamin President/CTO
> 
> The Linux Box
> 206 South Fifth Ave. Suite 150
> Ann Arbor, MI  48104
> 
> tel. 734-761-4689
> fax. 734-769-8938
> pgr. 734-431-0118
> 
> On Wed, 7 Feb 2001 dr...@ss... wrote:
> 
> 
> >
> > There is a way to pick the next set.  Use the offset keyword.
> >
> > select * from table where criteria offset START limit LENGTH
> >
> > --
> >   -- Drew Sullivan, <dr...@ss...> -- Toronto, Canada,  +1-416-512-2311
> >      Copyleft--all rights reversed
> >
> 
> 
> 

__________________________________________________
FREE voicemail, email, and fax...all in one place.
Sign Up Now! http://www.onebox.com