Use of the LIMIT clause ?

I read on a website dedicated to MySQL, that the limit clause allows
someone to restrict the result of a query to a certain domain.
Exemple : "select id, title from movie order by id limit 3" -> only the
(here, first) 3 lines of the table
I did knew about this, but the author goes further about the "limit
N,P", which allows someone to get only results between the Nth and Pth
lines of the whole result...
I tried this with psql, but couldn't get anything but parse errors.
However, "\h select" does mention "LIMIT [count, all] {offset, START}"
So, is it possible or not ? And what's the correct syntax ?

Thanks