Home > mailing lists

How to convert string to integer - Mailing list pgsql-sql

From	venkat
Subject	How to convert string to integer
Date	December 15, 2010 09:23:41
Msg-id	AANLkTin4L3=YrgrfymE2D2r0VAuec+-POZmb73aG5dJH@mail.gmail.com Whole thread Raw
Responses	Re: How to convert string to integer (Pavel Stehule <pavel.stehule@gmail.com>) Re: How to convert string to integer (Viktor Bojović <viktor.bojovic@gmail.com>) Re: [GENERAL] How to convert string to integer (Szymon Guz <mabewlun@gmail.com>)
List	pgsql-sql

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

From: Rob Sargent
Date: 14 December 2010, 17:14:58
Subject: Re: Using count on a join, group by required?

From: Pavel Stehule
Date: 15 December 2010, 09:28:38
Subject: Re: How to convert string to integer