Postgres Pro
Downloads
Home   >   mailing lists

Re: How to convert string to integer - Mailing list pgsql-general

From Szymon Guz
Subject Re: How to convert string to integer
Date
Msg-id AANLkTi==xC9HKA6RrxK9YtmdBQ3F2Q6W19xR3rL84p9u@mail.gmail.com
Whole thread Raw
In response to How to convert string to integer  (venkat <ven.tammineni@gmail.com>)
List pgsql-general
Tree view


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

pgsql-general by date:

Previous
From: venkat
Date:
Subject: How to convert string to integer
Next
From: Pavel Stehule
Date:
Subject: Re: [SQL] How to convert string to integer