Postgres Pro
Downloads
Home   >   mailing lists

Re: Returning String as Integer - Mailing list pgsql-sql

From Jorge Godoy
Subject Re: Returning String as Integer
Date
Msg-id 200605051852.19596.jgodoy@gmail.com
Whole thread Raw
In response to Returning String as Integer  ("Kashmira Patel \(kupatel\)" <kupatel@cisco.com>)
Responses Re: Returning String as Integer
List pgsql-sql
Tree view 
Em Sexta 05 Maio 2006 18:37, Kashmira Patel (kupatel) escreveu:
> Hi all,
>    I have a table with a column of type 'text'. It mainly contains
> numbers. Is there any way to select a value from this column and return
> it as an integer?

testing=# select '123'::integer;int4 
------ 123
(1 registro)

testing=# 


-- 
Jorge Godoy      <jgodoy@gmail.com>

pgsql-sql by date:

Previous
From: "Kashmira Patel \(kupatel\)"
Date:
Subject: Returning String as Integer
Next
From: elein
Date:
Subject: Re: Returning String as Integer