Explicit Cast

Поиск
Список
Период
Сортировка
От Rhaoni Chiu Pereira
Тема Explicit Cast
Дата
Msg-id 1061382268.3f43687cc3565@sistemica.info
обсуждение исходный текст
Ответы Re: Explicit Cast  (Stephan Szabo <sszabo@megazone.bigpanda.com>)
Список pgsql-admin
Hi List,

     As I already said .. I'm porting an Oracle DB to PostgreSQL and I must
rewrite most of the functions . So I have a problem to do something like this:

... atual_fatura in(''+'',''-'') ...

It gives me the following error:

 Unable to identify an operator '-' for types 'numeric' and 'character varying'
 You will have to retype this query using an explicit castenciosamente,

atual_fatura is a varchar field.

I read howto create an explicit cast but I didn't understand what I must do in
this case.

Can anybody help me ?


Rhaoni Chiu Pereira
Sistêmica Computadores

Visite-nos na Web: http://sistemica.info
Fone/Fax : +55 51 3328 1122






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

Предыдущее
От: "Nick Fankhauser"
Дата:
Сообщение: Re: changing field length
Следующее
От: "Somasekhar Bangalore"
Дата:
Сообщение: Need Help on query tuning