Horton

Thread

  1. BUG #17766: Issue in asc, limit and offset for pagination.

    PG Bug reporting form <noreply@postgresql.org> — 2023-02-01T06:38:47Z

    The following bug has been logged on the website:

Bug reference:      17766
Logged by:          PR Gopi krishnan
Email address:      prgopikrishnan85@gmail.com
PostgreSQL version: 15.1
Operating system:   windows and linux
Description:        

While getting the rows with the columns called name which has duplicate
names, now ascending the rows by name with limit 25 and offset 0,25,50 like
this on each query. But the rows are duplicating with the names

  2. Re: BUG #17766: Issue in asc, limit and offset for pagination.

    John Naylor <john.naylor@enterprisedb.com> — 2023-02-01T09:12:54Z

    On Wed, Feb 1, 2023 at 3:54 PM PG Bug reporting form <noreply@postgresql.org>
wrote:
> While getting the rows with the columns called name which has duplicate
> names, now ascending the rows by name with limit 25 and offset 0,25,50
like
> this on each query. But the rows are duplicating with the names

Hi,

You mentioned that the field has duplicate name values, so selecting that
column will produce a result set that has duplicates also. A "limit" clause
is not going to change that.

If you still think something is not behaving as expected, please provide a
reproducible test case.

--
John Naylor
EDB: http://www.enterprisedb.com

  3. Re: BUG #17766: Issue in asc, limit and offset for pagination.

    hubert depesz lubaczewski <depesz@depesz.com> — 2023-02-01T11:10:57Z

    On Wed, Feb 01, 2023 at 06:38:47AM +0000, PG Bug reporting form wrote:
> The following bug has been logged on the website:
> 
> Bug reference:      17766
> Logged by:          PR Gopi krishnan
> Email address:      prgopikrishnan85@gmail.com
> PostgreSQL version: 15.1
> Operating system:   windows and linux
> Description:        
> 
> While getting the rows with the columns called name which has duplicate
> names, now ascending the rows by name with limit 25 and offset 0,25,50 like
> this on each query. But the rows are duplicating with the names


This is not a bug. Simply make sure that your order by clause is over
unique combination.

So, if your name has duplicates, then add primary key to order by
clause:

order by name, id

depesz