Message-ID: <gh-pgjdbc-pgjdbc-4086@github.com>
From: "vlsi (@vlsi)" <noreply+vlsi@github.com>
To: "pgjdbc/pgjdbc" <noreply+pgjdbc-pgjdbc@github.com>
Date: Fri, 22 May 2026 08:41:36 +0000
Subject: [pgjdbc/pgjdbc] issue #4086: Support JDBC SQL_TSI_FRAC_SECOND in timestampadd/timestampdiff escapes
List-Id: <gh-pgjdbc-pgjdbc.github.com>
X-GitHub-Author-Id: 213894
X-GitHub-Author-Login: vlsi
X-GitHub-Issue: 4086
X-GitHub-Repo: pgjdbc/pgjdbc
X-GitHub-State: open
X-GitHub-Type: issue
X-GitHub-Url: https://github.com/pgjdbc/pgjdbc/issues/4086
Content-Type: text/plain; charset=utf-8

EscapedFunctions2 currently rejects `SQL_TSI_FRAC_SECOND` for `timestampadd` and `timestampdiff`, while JDBC escape syntax includes fractional-second intervals. Investigate mapping `FRAC_SECOND` to PostgreSQL intervals/extract semantics and add parser tests for supported precision