Postgres Pro
Downloads
Home   >   mailing lists

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

From Viktor Bojović
Subject Re: How to convert string to integer
Date
Msg-id AANLkTikutYUZxGkjSe4tSGwgsS+9v2HY9j_qkm+ehgVH@mail.gmail.com
Whole thread Raw
In response to How to convert string to integer  (venkat <ven.tammineni@gmail.com>)
List pgsql-sql
Tree view


On Wed, Dec 15, 2010 at 11:23 AM, 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'

also you can use conversion functions described here

--
---------------------------------------
Viktor Bojović
---------------------------------------
Wherever I go, Murphy goes with me

pgsql-sql by date:

Previous
From: Pavel Stehule
Date:
Subject: Re: How to convert string to integer
Next
From: serviciotdf
Date:
Subject: Translate Function PL/pgSQL to SQL92