I have this method

I need to score a string @param (“key”) String Key to the value of int in order to get the size of the collection of a.size
How to do it in my case?

Answer 1

or a.size = Cast (: key as bigint)

For Postgres it works.

There is another option, but it often does not work in such requests –

or a.size =: Key :: bigint