Re: Parameter marker swapping in {fn timestampdiff()}

Thanks, reposted.

On Sun, Mar 26, 2023 at 11:54 AM Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> wrote:

> Matthew Bellew <matthewb(at)labkey(dot)com> writes:
> > I recently made a small change to a core utility and our sql tests
> flagged
> > some unexpected results. I traced these to timestampdiff(). Below is a
> > running code function (except for creating the JDBC Connection). I
> expect
> > the same result for all three executeQuery() calls. The version that
> uses
> > string literals return 366 and the versions that use parameter markers
> > return -366.
>
> You probably want to report that on the pgsql-jdbc list. This list
> mainly deals in bugs in core Postgres, so I'm not very sure whether
> the JDBC maintainers read it.
>
> regards, tom lane
>