How to convert string to integer

From: venkat <ven(dot)tammineni(at)gmail(dot)com>
To: Postgres General <pgsql-general(at)postgresql(dot)org>, pgsql-sql(at)postgresql(dot)org
Subject: How to convert string to integer
Date: 2010-12-15 10:23:32
Message-ID: AANLkTin4L3=YrgrfymE2D2r0VAuec+-POZmb73aG5dJH@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general 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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Szymon Guz 2010-12-15 10:27:37 Re: How to convert string to integer
Previous Message Dmitriy Igrishin 2010-12-15 09:57:20 Re: C++ code - PGRES_TUPLES_OK is not returned when DELETE performed

Browse pgsql-sql by date

  From Date Subject
Next Message Szymon Guz 2010-12-15 10:27:37 Re: How to convert string to integer
Previous Message Rob Sargent 2010-12-14 18:14:45 Re: Using count on a join, group by required?