Message-ID: <gh-pgjdbc-pgjdbc-3567-c2729255676@github.com>
From: "davecramer (@davecramer)" <noreply+davecramer@github.com>
To: "pgjdbc/pgjdbc" <noreply+pgjdbc-pgjdbc@github.com>
Date: Mon, 17 Mar 2025 12:10:27 +0000
Subject: Re: [pgjdbc/pgjdbc] issue #3567: Surprising behaviour with jagged arrays
In-Reply-To: <gh-pgjdbc-pgjdbc-3567@github.com>
References: <gh-pgjdbc-pgjdbc-3567@github.com>
List-Id: <gh-pgjdbc-pgjdbc.github.com>
X-GitHub-Author-Login: davecramer
X-GitHub-Comment-Id: 2729255676
X-GitHub-Comment-Type: issue_comment
X-GitHub-Issue: 3567
X-GitHub-Repo: pgjdbc/pgjdbc
X-GitHub-Type: comment
X-GitHub-Url: https://github.com/pgjdbc/pgjdbc/issues/3567#issuecomment-2729255676
Content-Type: text/plain; charset=utf-8

> [@davecramer](https://github.com/davecramer) wow, you are fast! 🙇
> 
Depends on the day :)

> PostgreSQL does not support jagged arrays. I guess the codec could validate that the array shape is rectangular. `ArrayEncoding` already [iterates over all rows](https://github.com/pgjdbc/pgjdbc/blob/d86d7ce19030230f14e573b8095f04721d1d8e35/pgjdbc/src/main/java/org/postgresql/jdbc/ArrayEncoding.java#L1236-L1239) anyway so it could validate the size of each row is the same. I can send a PR draft if that helps.
Please do