How to call 'like any' PostgreSQL function in JPQL

Question

I have next issue: I have list of names, based on which I want to filter.The problem is that I have not full names(Because I'm receiving them from ui), and I have, for example, this array= ['Joh', 'Michae'].

So, I want to filter based on this array.

I wrote query in PostgreSQL

select * from q_ob_person where name  like any (array['%Хомяченко%', '%Вартопуз%']);

And I want to ask how to write JPQL query gor this.

Is there an option to call postgresql function like any from JPQL?

Neil Stockton · Accepted Answer · 2015-06-20 09:12:16Z

2

JPA 2.1 allows invocation of any SQL function using

FUNCTION(sqlFuncName, sqlArgs)

So you could likely do something like (note never tried this LIKE ANY you refer to, just play around with it)

FUNCTION("LIKE", FUNCTION("ANY", arrayField))

Obviously by invoking SQL functions specific to a particular RDBMS you lose database independence (in case that's of importance).

edited Jun 20, 2015 at 9:12

answered Jun 19, 2015 at 15:13

Neil Stockton

11.6k3 gold badges36 silver badges29 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Ivan Ursul Over a year ago

Thanks, I will try to find more information about that

Collectives™ on Stack Overflow

How to call 'like any' PostgreSQL function in JPQL

1 Answer 1

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related