Hi there! I'm needing to only call a certain number of records based on the page the user is on . When the user clicks 'next' the next page displays the next set of results (obviously). At the moment I'm loading the whole result set every page and just limiting what the user sees. This way is very slow because everytime i'm calling the entire result set. Any way around this with modifying my SQL statement to just call records (i.e.) between 20 and 40 ? (and then the next page calling 40 and 60, etc.)

You might be able to limit the resultset with a "WHERE" clause. It'll probably depend on the structure of your data. Unfortunately, there's no "LIMIT" clause in PSQL.