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@xxxxxxxxx>: > 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 > > -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
