Re: Explicit Cast

Поиск
Список
Период
Сортировка
Искать

Re: Explicit Cast

От:
"Mendola Gaetano" <mendola@bigfoot.com>
Дата:
"Rhaoni Chiu Pereira"  wrote:
> 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 ?

May we have more details on it ? Seems that you want add a numeric with a
varchar.


Regards
Gaetano Mendola

Explicit Cast

От:
Rhaoni Chiu Pereira <rhaoni@sistemica.info>
Дата:
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

Re: Explicit Cast

От:
Stephan Szabo <sszabo@megazone.bigpanda.com>
Дата:
On Wed, 20 Aug 2003, Rhaoni Chiu Pereira wrote:

> 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 you send the actual function you're having problems with and version
information?  I don't seem to get an error with a simple function that
uses such a construct on 7.3.4, but I expect the real example is more
complicated.
FAQ