http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=11422 Bug ID: 11422 Summary: LIMIT $offset, $limit not compatible with PostgreSQL Change sponsored?: --- Product: Koha Version: master Hardware: All OS: All Status: NEW Severity: enhancement Priority: P5 - low Component: Architecture, internals, and plumbing Assignee: gmcharlt@gmail.com Reporter: gmcharlt@gmail.com QA Contact: testopia@bugs.koha-community.org Blocks: 7365 There are some queries that use "LIMIT $offset, $limit" which PostgreSQL will not accept. However, PostgreSQL *does* accept "LIMIT $limit OFFSET $offset". Since MySQL accepts that construct as well, we should use it. A partial list of code using LIMIT x,y is: offline_circ/download.pl reports/borrowers_out.pl reports/catalogue_out.pl t/db_dependent/Labels/t_Batch.t t/db_dependent/Reports/Guided.t misc/migration_tools/rebuild_zebra.pl C4/VirtualShelves.pm C4/Utils/DataTables.pm C4/Reports/Guided.pm C4/Review.pm C4/Serials.pm C4/NewsChannel.pm (in a comment only) C4/Koha.pm C4/Items.pm C4/Acquisition.pm Note that because of a quirk in DBI, the technique described at http://www.perlmonks.org/?node_id=837422 needs to be used when using a placeholder for the OFFSET value. -- You are receiving this mail because: You are watching all bug changes.