Casting from varchar to numeric

Поиск
Список
Период
Сортировка
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 по дате отправления:

Предыдущее
От: gerry.smit@lombard.ca
Дата:
Сообщение: Re: Answering my own question
Следующее
От: "Adam Erickson"
Дата:
Сообщение: Re: Answering my own question