Re: Postgres offset and limit bug

From: David Rowley <dgrowleyml(at)gmail(dot)com>
To: Ming <ming(at)cleanstormwater(dot)com(dot)au>
Cc: "pgsql-bugs(at)lists(dot)postgresql(dot)org" <pgsql-bugs(at)lists(dot)postgresql(dot)org>
Subject: Re: Postgres offset and limit bug
Date: 2022-09-08 08:36:04
Message-ID: CAApHDvqUW8homCjinMhr6OyoX=6MYy1MDj_Mzq440+19gOxa-Q@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

On Thu, 8 Sept 2022 at 19:20, Ming <ming(at)cleanstormwater(dot)com(dot)au> wrote:
> We recently found a strange behavior on Postgres SQL. The offset function will not acting properly when having limit in the query. I want to confirm that it's an existing bug or it's my syntax is wrong.

Nothing looks wrong from here. Can you describe what behaviour you're expecting?

David

In response to

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Ming 2022-09-08 08:48:58 Re: Postgres offset and limit bug
Previous Message James Pang (chaolpan) 2022-09-08 06:10:28 huge memory of Postgresql backend process