Re: BUG #14411: Issue with using OFFSET

From: Victor Yegorov <vyegorov(at)gmail(dot)com>
To: Jamie Koceniak <jkoceniak(at)mediamath(dot)com>
Cc: Kevin Grittner <kgrittn(at)gmail(dot)com>, "pgsql-bugs(at)postgresql(dot)org" <pgsql-bugs(at)postgresql(dot)org>
Subject: Re: BUG #14411: Issue with using OFFSET
Date: 2016-11-04 16:38:09
Message-ID: CAGnEboiWJdj_JEikvNaEKwPB=37nwO_aQc08P+kxzj=aF-EGpg@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

2016-11-04 2:05 GMT+02:00 Jamie Koceniak <jkoceniak(at)mediamath(dot)com>:

> I would be interested in hearing about alternate solutions to using OFFSET.

I find this presentation useful in describing how to do pagination:
http://www.slideshare.net/MarkusWinand/p2d2-pagination-done-the-postgresql-way

--
Victor Yegorov

In response to

Browse pgsql-bugs by date

  From Date Subject
Next Message bernhard.rieder 2016-11-04 23:56:41 BUG #14413: pgadmin3 crashes on start
Previous Message harry 2016-11-04 14:55:37 BUG #14412: Problems upgrading Postgresql