Re: Explicit Cast

"Rhaoni Chiu Pereira" <rhaoni@sistemica.info> 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