perl-modperl mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Malcolm J Harwood <mjhlist-modp...@liminalflux.net>
Subject Re: Database transaction across multiple web requests
Date Fri, 31 Mar 2006 20:04:51 GMT
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"

Mime
View raw message