Message-ID: <gh-pgjdbc-pgjdbc-3567-c2729239559@github.com>
From: "jerrinot (@jerrinot)" <noreply+jerrinot@github.com>
To: "pgjdbc/pgjdbc" <noreply+pgjdbc-pgjdbc@github.com>
Date: Mon, 17 Mar 2025 12:05:50 +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: jerrinot
X-GitHub-Comment-Id: 2729239559
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-2729239559
Content-Type: text/plain; charset=utf-8

@davecramer wow, you are fast! 🙇 

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.