Ooops.. didn't notice the LIMIT # OFFSET # part. IMHO the idea soundsgood and is definitely more readable.. and fair to both Mysql andpostgresql loyalists ;).
Postgres is backwards? Or did you mean you got the syntax backwards ?;).