Use LIMIT...OFFSET syntax understood both by MySQL and PG.
Use PG's native impl.