Postgres Pro
Downloads
Home   >   mailing lists

Thread: How to convert string to integer

How to convert string to integer

From
venkat
Date:
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

Re: How to convert string to integer

From
Szymon Guz
Date:


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

Re: [SQL] How to convert string to integer

From
Pavel Stehule
Date:
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
>
>

Re: [SQL] How to convert string to integer

From
Viktor Bojović
Date:


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

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