On Wed, 18 Dec 2002 11:13:50 +0000, Ken Guest <kguest(at)stockbyte(dot)com>
wrote:
>How do I cast/convert a string value to an integer in 7.1.3?
>I've tried using cast but it doesn't seem to work.
fred=# SELECT version();
version
--------------------------------------------------------------
PostgreSQL 7.1.3 on i686-pc-cygwin, compiled by GCC 2.95.3-5
(1 row)
fred=# SELECT '123'::INT;
?column?
----------
123
(1 row)
fred=# SELECT CAST('123' AS INT);
?column?
----------
123
(1 row)
Does this answer your question? If not, show us an example of what
you have tried.
Servus
Manfred