Re: "could not determine data type of parameter" with timestamp

On Tue, Dec 5, 2017 at 8:11 AM, Rémi Aubel <remi(dot)aubel(at)gmail(dot)com> wrote:

> Hello,
>
> I know my problem has already been answered in this list (
> https://www.postgresql.org/message-id/CA%2BxsaB0EMDaNek0Oky9c17_8UX3-
> epWVP11%2BvTNgrAPoY2s9FA%40mail.gmail.com), but it was a long time ago
> and I would like to know if any other solution exists now.
>

​Not that I am aware.​

> But this workaround is not really useful for me, because my application
> uses generated (dynamic) queries and targets multiple database types (not
> only PosgreSQL). So, when I know the targeted database, I do not know my
> parameter types anymore.
>

​I'd probably perform the null test in Java and pass the true/false boolean
result along to the query:

SELECT * FROM my_table WHERE ?::bool;
ps.setBoolean(1, tsvar = null); //my Java is rusty but you get the idea.

That should work in any database.

David J.
​