I was starting to poke around DBIx::SearchBuilder for any fixes that
might be needed for Postgres 7.3. I’m not seeing how SearchBuilder
really knows which DB it is using when, for example, generating the
LIMIT clause. The one there never should have worked considering that
PG implemented LIMIT X,Y backwards from MySQL (the offset/count order
was reversed). This is why the preferred LIMIT X OFFSET Y format was
kept in favor of the other format.
So, how does it tell which DB it is using when generating these
things? Do I just override the method in SearchBuilder’s Pg module?
Once that’s fixed, it is on to track down all the implicit ‘’ => 0
casts that need to be found and fixed…