Returning String as Integer

From: "Kashmira Patel \(kupatel\)" <kupatel(at)cisco(dot)com>
To: <pgsql-sql(at)postgresql(dot)org>
Subject: Returning String as Integer
Date: 2006-05-05 21:37:13
Message-ID: 18AE59788A3FC640A367E5652E664D8002093F0C@xmb-sjc-237.amer.cisco.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

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?

Thanks,
Kashmira

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message elein 2006-05-05 21:51:49 Re: Returning String as Integer
Previous Message Markus Schaber 2006-05-05 08:17:38 Re: How can I read display message from a C function