>> Granted, I use a few MySQL features for this; I'm not sure if LIMIT >> exists in postgresql, and ... > > PostgreSQL has LIMIT... it's a SQL standard.
PostgreSQL uses LIMIT 10 OFFSET 20 where mysql uses LIMIT 20,10 (notice the swap). I don't know if it is "standard", but if it is, vendors aren't following the standard.
