Postgres Pro
Downloads
Home   >   mailing lists

Re: Postgres offset and limit bug - Mailing list pgsql-bugs

From David Rowley
Subject Re: Postgres offset and limit bug
Date
Msg-id CAApHDvqUW8homCjinMhr6OyoX=6MYy1MDj_Mzq440+19gOxa-Q@mail.gmail.com
Whole thread Raw
In response to Postgres offset and limit bug  (Ming <ming@cleanstormwater.com.au>)
Responses Re: Postgres offset and limit bug
List pgsql-bugs
Tree view 
On Thu, 8 Sept 2022 at 19:20, Ming <ming@cleanstormwater.com.au> wrote:
> We recently found a strange behavior on Postgres SQL. The offset function will not acting properly when having limit
inthe 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

pgsql-bugs by date:

Previous
From: "James Pang (chaolpan)"
Date:
Subject: huge memory of Postgresql backend process
Next
From: Ming
Date:
Subject: Re: Postgres offset and limit bug