<Querying by value in JSONB field in h2/postgresql...
# stackoverflow
u
Querying by value in JSONB field in h2/postgresql I have following json field in entity: {"uuid", "uuid2"} and I want to use @Query to find an entity which contains given uuid in this field. I have found a solution for postgresql (which we are using), but when I try to test it using h2 I get Function JSONB_EXISTS not found exception. Is it possible to make it work with both postgresql and h2 using same query? How I am creating a query (this works fine for postgresql, but not for h2): @Query( nativeQuery = true, value = "SELECT * FROM...