Hi,
I have a simple table foo with a column guid of data type uuid
if I execute the following query
select guid from foo where guid = '849b3d72-1400-44f1-
a965-1f4648475589'
the query returns fine
but if I parameterize the query as this
select guid from foo where guid = ?
and I set the the parameter using setString(1, '849b3d72-1400-44f1-
a965-1f4648475589')
the query bombs with the following:
[Error Code: 0, SQL State: 42883] ERROR: operator does not exist:
uuid = character varying
I understand I need to use setObject(), or that I could explicitly
cast it (select guid from foo where guid = ?::uuid) but I don't
understand why harcoding a string works, and sending a string
parameter does not
Ciao
Stefano