Message-ID: <gh-pgjdbc-pgjdbc-1225-c516376582@github.com>
From: "findepi (@findepi)" <noreply+findepi@github.com>
To: "pgjdbc/pgjdbc" <noreply+pgjdbc-pgjdbc@github.com>
Date: Tue, 30 Jul 2019 11:18:52 +0000
Subject: Re: [pgjdbc/pgjdbc] issue #1225: Java 8 Time Support for Postgres Arrays
In-Reply-To: <gh-pgjdbc-pgjdbc-1225@github.com>
References: <gh-pgjdbc-pgjdbc-1225@github.com>
List-Id: <gh-pgjdbc-pgjdbc.github.com>
X-GitHub-Author-Login: findepi
X-GitHub-Comment-Id: 516376582
X-GitHub-Comment-Type: issue_comment
X-GitHub-Issue: 1225
X-GitHub-Repo: pgjdbc/pgjdbc
X-GitHub-Type: comment
X-GitHub-Url: https://github.com/pgjdbc/pgjdbc/issues/1225#issuecomment-516376582
Content-Type: text/plain; charset=utf-8

@davecramer let's discuss API first.

When _reading_ one could use `rs.getObject(column, LocalDateTime[].class)` to request lossless representation of PG's `timestamp[]`.
However, to handle multi-dimensional arrays, this could get cumbersome and `rs.getArray(column)` doesn't provide a way to request a specific representation. (I am convinced changing existing behavior is no-go.)

- do we need an initialization property?
- or a PG-specific method?

When _writing_ it should be easier. We can accept (multi-dim) arrays of `LocalDateTime`. We still want https://github.com/pgjdbc/pgjdbc/issues/1390