Re: [SQL] How to convert string to integer

Lists: pgsql-generalpgsql-sql
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
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

From: Szymon Guz <mabewlun(at)gmail(dot)com>
To: venkat <ven(dot)tammineni(at)gmail(dot)com>
Cc: Postgres General <pgsql-general(at)postgresql(dot)org>, pgsql-sql(at)postgresql(dot)org
Subject: Re: How to convert string to integer
Date: 2010-12-15 10:27:37
Message-ID: AANLkTi==xC9HKA6RrxK9YtmdBQ3F2Q6W19xR3rL84p9u@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Lists: pgsql-general pgsql-sql

On 15 December 2010 11:23, venkat <ven(dot)tammineni(at)gmail(dot)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'

but this will work only if for all rows you can convert this field to
integer

regards
Szymon Guz

From: Pavel Stehule <pavel(dot)stehule(at)gmail(dot)com>
To: venkat <ven(dot)tammineni(at)gmail(dot)com>
Cc: Postgres General <pgsql-general(at)postgresql(dot)org>, pgsql-sql(at)postgresql(dot)org
Subject: Re: [SQL] How to convert string to integer
Date: 2010-12-15 10:27:50
Message-ID: AANLkTikfbTjg2=wo3+FH67VtfWFUYdno0YN=8qRFf1JX@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Lists: pgsql-general pgsql-sql

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(dot)tammineni(at)gmail(dot)com>:
> 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: Viktor Bojović <viktor(dot)bojovic(at)gmail(dot)com>
To: venkat <ven(dot)tammineni(at)gmail(dot)com>
Cc: Postgres General <pgsql-general(at)postgresql(dot)org>, pgsql-sql(at)postgresql(dot)org
Subject: Re: [SQL] How to convert string to integer
Date: 2010-12-15 10:37:34
Message-ID: AANLkTikutYUZxGkjSe4tSGwgsS+9v2HY9j_qkm+ehgVH@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Lists: pgsql-general pgsql-sql

On Wed, Dec 15, 2010 at 11:23 AM, venkat <ven(dot)tammineni(at)gmail(dot)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
http://www.postgresql.org/docs/8.2/static/functions-formatting.html

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