[prev in list] [next in list] [prev in thread] [next in thread] 

List:       apache-modperl
Subject:    Re: Database transaction across multiple web requests
From:       Malcolm J Harwood <mjhlist-modperl () dalereuth ! liminalflux ! net>
Date:       2006-03-31 20:04:51
Message-ID: 200603311504.54598.mjhlist-modperl () liminalflux ! net
[Download RAW message or body]

On Friday 31 March 2006 02:10 pm, Jonathan Vanasco wrote:
> On Mar 31, 2006, at 2:00 PM, Frank Wiles wrote:
> >   Yup, you're right I just double checked and there isn't a LIMIT/
> > OFFSET
> >   in the SQL standard.  For someone reason... probably because it's so
> >   freaking useful, I assumed it was. :)
>
> I was pretty floored when i found out myself.  I *think* more dbs
> tend to do LIMIT x OFFSET x from what i've seen, but its just not in
> the spec.  Crazy.

Just to be different, MS-SQL uses TOP...
which goes at the begining of the query, not the end:
	SELECT TOP 10 ...
rather than
	SELECT ... LIMIT 10.
:-/

-- 
"The Universe doesn't give you any points for doing things that are easy."
- Sheridan to Garibaldi in Babylon 5:"The Geometry of Shadows"
[prev in list] [next in list] [prev in thread] [next in thread]