Esta crónica ha sido aprobado por nuestros expertos para que tengas la garantía de la veracidad de nuestra esta reseña.
Ejemplo 1: reparto postgresql
SELECT '100'::INTEGER;
SELECT CAST ('100' AS INTEGER);
Ejemplo 2: postgres convertir número a string
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
¡Haz clic para puntuar esta entrada!
(Votos: 0 Promedio: 0)