Postgres Pro
Downloads
Home   >   mailing lists

Postgres offset and limit bug - Mailing list pgsql-bugs

From Ming
Subject Postgres offset and limit bug
Date
Msg-id Mailbird-7af33f94-f8ca-401e-be1e-086ac6504238@cleanstormwater.com.au
Whole thread Raw
Responses Re: Postgres offset and limit bug
List pgsql-bugs
Tree view
Hello,

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.  

Please find the attachments for details. 

Client: PgAdmin
Client System: Windows 11
Instance: AWS RDS PostgreSQL 13.4


Mingxuan Chen
Software Engineera: w:
CleanStormWaterp: 0461602352e: mingxuan_chen@outlook.com
Attachment

pgsql-bugs by date:

Previous
From: Peter Geoghegan
Date:
Subject: Re: PANIC in heap_delete during ALTER TABLE
Next
From: "qiumingcheng"
Date:
Subject: A problem about LEAKPROOF of postgresql