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

Question

How do I convert an integer to string as part of a PostgreSQL query   So  for example  I need   SELECT   FROM table WHERE  lt some integer gt     string of numbers    where  lt some integer gt  can be anywhere from 1 to 15 digits long

User · Accepted Answer

Because the number can be up to 15 digits, you'll need to cast to an 64 bit (8-byte) integer. Try this:

SELECT * FROM table
WHERE myint = mytext::int8

The :: cast operator is historical but convenient. Postgres also conforms to the SQL standard syntax

myint = cast ( mytext as int8)

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

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

User · Answer

You can cast an integer to a string in this way   intval  text   and so in your case  SELECT   FROM table WHERE  lt some integer gt   text    string of numbers

User · Answer

You could do this   SELECT   FROM table WHERE cast YOUR INTEGER VALUE as varchar     string of numbers

[postgresql] How do I convert an integer to string as part of a PostgreSQL query?

Examples related to postgresql

Examples related to postgresql-9.1