Why isn't LIMIT functionality included in CDBI?

[prev] [thread] [next] [Date index for 2004/05/21]

Why isn't LIMIT functionality included in CDBI?

I know different database engines have different syntax for LIMIT, i.e. 
MySQL uses LIMIT x,y whereas Postgres uses LIMIT x OFFSET y, but still 
the developer could just write:

{ limit => "x,y" }, if he uses MySQL, and
{ limit => "x offset y" }, if he uses Postgres.

Is there any reason this isn't desirable behaviour?

Perhaps it should be implemented somewhere in Class::DBI::mysql?

Alex