Home sql how to make caste strings in int sql

how to make caste strings in int sql




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

Programmers, Start Your Engines!

Why spend time searching for the correct question and then entering your answer when you can find it in a second? That's what CompuTicket is all about! Here you'll find thousands of questions and answers from hundreds of computer languages.

Recent questions