How to convert an integer to a string as part of a PostgreSQL query?

Question

How to convert an integer to a string as part of a PostgreSQL query?

So, for example, I need:

SELECT * FROM table WHERE <some integer> = 'string of numbers' 

where <some integer> can be between 1 and 15 digits long.

Answer 1

Since a number can be up to 15 digits, you need to cast to a 64-bit (8-byte) integer. Try this:

 SELECT * FROM table WHERE myint = mytext::int8 

The :: cast operator is historical, but convenient. Postgres also follows standard SQL syntax

 myint = cast ( mytext as int8) 

---

If you have literal text that you want to compare with int , cast int to text:

 SELECT * FROM table WHERE myint::varchar(255) = mytext 

Answer 2

This way you can highlight an integer in a string

 intval::text 

and therefore in your case

 SELECT * FROM table WHERE <some integer>::text = 'string of numbers' 

Answer 3

You could do this:

SELECT * FROM table WHERE cast (YOUR_INTEGER_VALUE as varchar) = 'string of numbers'