Cast char to number

From: Christine Penner <christine(at)ingenioussoftware(dot)com>
To: Postgres-General <pgsql-general(at)postgresql(dot)org>
Subject: Cast char to number
Date: 2010-02-24 19:36:14
Message-ID: 19740413053640.0536B1E16B8CBE0F@edtnaa02.telusplanet.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

I have a character field I want to change to a number. The values in
that field are all numbers that may or may not be padded with spaces
or 0's. What is the best way to do that?

Christine Penner
Ingenious Software
250-352-9495
christine(at)ingenioussoftware(dot)com

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Bill Moran 2010-02-24 19:38:47 Re: Cast char to number
Previous Message Greg Smith 2010-02-24 18:09:44 Re: pg_buffercache's usage count