Postgres Pro
Downloads
Home   >   mailing lists

Cast char to number - Mailing list pgsql-general

From Christine Penner
Subject Cast char to number
Date
Msg-id 19740413053640.0536B1E16B8CBE0F@edtnaa02.telusplanet.net
Whole thread Raw
Responses Re: Cast char to number  (Bill Moran <wmoran@potentialtech.com>)
List pgsql-general
Tree view 
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@ingenioussoftware.com

pgsql-general by date:

Previous
From: Greg Smith
Date:
Subject: Re: pg_buffercache's usage count
Next
From: Bill Moran
Date:
Subject: Re: Cast char to number