VARCHAR to INTEGER conversion

Поиск
Список
Период
Сортировка
От Darren Ferguson
Тема VARCHAR to INTEGER conversion
Дата
Msg-id Pine.LNX.4.10.10201161852270.30914-100000@thread.crystalballinc.com
обсуждение исходный текст
Ответы Re: VARCHAR to INTEGER conversion  (Stephan Szabo <sszabo@megazone23.bigpanda.com>)
Re: VARCHAR to INTEGER conversion  (Jeff Eckermann <jeff_eckermann@yahoo.com>)
Список pgsql-general
Hello list

I have a stored procedure that takes in an integer

sp_customer_service_property_descr(INTEGER)

However i have a database field that is a VARCHAR because it can take
either a number that would have to go into this stored procedure or it can
just have normal text depending on the value of another field.

I tried casting the VARCHAR as an INTEGER postgres (V7.2b4) doesn't let me
do this. Now i understand why it is not letting me do this however here is
my question

Does anyone know of a work around so that i can call this function with
the varchar database field.

Thanks in advance

Darren Ferguson



В списке pgsql-general по дате отправления:

Предыдущее
От: Joseph Shraibman
Дата:
Сообщение: Re: large number of files open...
Следующее
От: Rob Brown-Bayliss
Дата:
Сообщение: external input for primary key