Postgres Pro
Downloads
Home   >   mailing lists

Casting from varchar to numeric - Mailing list pgsql-novice

From Tom Ansley
Subject Casting from varchar to numeric
Date
Msg-id 200205160948.47196.tansley@law.du.edu
Whole thread Raw
Responses Re: Casting from varchar to numeric  ("Josh Berkus" <josh@agliodbs.com>)
Re: Casting from varchar to numeric  ("Adam Erickson" <adamre@cox.net>)
Re: Casting from varchar to numeric  (Tom Ansley <tansley@law.du.edu>)
Re: Casting from varchar to numeric  ("Joel Burton" <joel@joelburton.com>)
List pgsql-novice
Tree view 
Hi list,

Is there a way of casting from a varchar to a numeric type?

My problem consists of a varchar(10) that are all numeric.  They are telephone
numbers and I want to convert them during a select statement to (XXX)
XXX-XXXX

Anybody have any ideas?

Thanks

Tom

pgsql-novice by date:

Previous
From: gerry.smit@lombard.ca
Date:
Subject: Re: Answering my own question
Next
From: "Adam Erickson"
Date:
Subject: Re: Answering my own question