Re: converting string value to integer

On Wed, 18 Dec 2002 11:13:50 +0000, Ken Guest <kguest@stockbyte.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