Postgresql with sql pagination

[bjverde]

LIMIT and OFFSET work PostgreSQL >= 9.4

See documentation

• https://www.postgresql.org/docs/9.6/queries-limit.html
• https://www.technobytz.com/limit-offset-order-by-and-pagination-in-postgresql.html
• https://leopard.in.ua/2014/10/11/postgresql-paginattion#.Xc4a4a9v-po

See on code

• TGeneratorHelper::getConfigByDBMS
• TCreateDAO::addSqlSelectAllPagination

[bjverde]

SELECT * FROM pessoal.tb_apoio order by cd_apoio LIMIT 5 OFFSET 10 ;

LIMIT qtd row OFFSET = row start - 1