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

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

>
-jason scott gessner
     jason@xxxxxxxx.xxx
> 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
>

well, in MySQL at least, OFFSET is only used as an optional 2nd 
argument to LIMIT, so i think the interface through C::DBI::Mysql 
should be as it is in the patc.

As i don't have a postgresql install handy, I will leave it for now.

comments?