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>:
> 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
>
>