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

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

Examples related to postgresql

• Subtracting 1 day from a timestamp date • pgadmin4 : postgresql application server could not be contacted. • Psql could not connect to server: No such file or directory, 5432 error? • How to persist data in a dockerized postgres database using volumes • input file appears to be a text format dump. Please use psql • Postgres: check if array field contains value? • Add timestamp column with default NOW() for new rows only • Can't connect to Postgresql on port 5432 • How to insert current datetime in postgresql insert query • Connecting to Postgresql in a docker container from outside

Examples related to postgresql-9.1

• Postgresql SQL: How check boolean field with null and True,False Value? • must appear in the GROUP BY clause or be used in an aggregate function • postgres, ubuntu how to restart service on startup? get stuck on clustering after instance reboot • List tables in a PostgreSQL schema • PostgreSQL ERROR: canceling statement due to conflict with recovery • How do I convert an integer to string as part of a PostgreSQL query? • ALTER TABLE, set null in not null column, PostgreSQL 9.1 • Strange PostgreSQL "value too long for type character varying(500)" • PostgreSQL next value of the sequences? • Change type of varchar field to integer: "cannot be cast automatically to type integer"