Thread: converting string value to integer
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. k. ________________________________________________________________________ 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 ________________________________________________________________________
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 ________________________________________________________________________