[Maypole] no use of LIMIT in sql queries
Perrin Harkins
perrin@elem.com
Tue, 29 Jun 2004 19:47:33 -0400
On Tue, 2004-06-29 at 19:22, Kevin wrote:
> Any idea what I'm missing here? Why do no perl database modules support
> the use of limits in select queries?
There was some discussion of this on the Class::DBI list, so please take
a look. As I recall, the gist of it was that LIMIT is proprietary to
MySQL and there is no equivalent that is supported by all SQL92
databases (although some other databases have their own incompatible
syntax for it), so if someone wants this it needs to go into
Class::DBI::MySQL. Feel free to raise it on the list again though if
you have more ideas or patches.
- Perrin