Re: [SQL] How to convert string to integer

[Viktor BojoviÄ <viktor.bojovic@xxxxxxxxx>]

On Wed, Dec 15, 2010 at 11:23 AM, venkat <ven.tammineni@xxxxxxxxx> 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