How to convert string to integer

On 15 December 2010 11:23, venkat <ven.tammineni@gmail.com> wrote:

Dear All,

How do i convert string to int

select SUM(pan_1) from customers1 where name='101'

When i run the above query i m getting "function sum(character varying)
does not exist"..

Please anyone can guide me..

Thanks

select SUM(pan_1::integer) from customers1 where name='101'

but this will work only if for all rows you can convert this field to
integer

regards
Szymon Guz

Hello

you can use a ::int for converting to integer. Or better - you can
alter column to integer. It will be faster and more correct.

Regards

Pavel Stehule

2010/12/15 venkat <ven.tammineni@gmail.com>:

On Wed, Dec 15, 2010 at 11:23 AM, venkat <ven.tammineni@gmail.com> wrote:

Dear All,

How do i convert string to int

select SUM(pan_1) from customers1 where name='101'

When i run the above query i m getting "function sum(character varying)
does not exist"..

Please anyone can guide me..

Thanks

select SUM(pan_1::integer) from customers1 where name='101'

also you can use conversion functions described here
http://www.postgresql.org/docs/8.2/static/functions-formatting.html

--
---------------------------------------
Viktor Bojović
---------------------------------------
Wherever I go, Murphy goes with me