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

Manfred Koizar wrote:

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.

<snip>

Does this answer your question? If not, show us an example of what
you have tried.

It does indeed. There were some trailing spaces which I was unaware of,
so I'm now using something akin to
SELECT CAST(TRIM('123 ') AS INT);

which works perfectly.

Thank you Manfred,

ken

________________________________________________________________________
This email has been scanned for all viruses by the MessageLabs SkyScan
service. For more information on a proactive anti-virus service working
around the clock, around the globe, visit http://www.messagelabs.com
________________________________________________________________________