Re: Patch for Class::DBI::MySQL to support LIMIT

[prev] [thread] [next] [Date index for 2004/07/27]

jason scott gessner wrote:

> the patch says it all.
> 
>         if ( $search_opts->{limit} =~ m/^(\d+\s?,\s?)?\d+$/ ) {
>             $frag .= " LIMIT $search_opts->{limit}"

I think you'd have to add support for OFFSET as well, since Mysql
supports that, and Postgres requires it.
This should work:

	m/^(\d+\s?(?:,|OFFSET)\s?)?\d+$/i

> Sorry, just thinking out loud.

As do I ;-)

Rhesa