Re: Explicit Cast - Mailing list pgsql-admin

From Mendola Gaetano
Subject Re: Explicit Cast
Date
Msg-id 002201c3672e$68bb0770$32add6c2@mm.eutelsat.org
Whole thread Raw
In response to Explicit Cast  (Rhaoni Chiu Pereira <rhaoni@sistemica.info>)
List pgsql-admin
"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



pgsql-admin by date:

Previous
From: "Mendola Gaetano"
Date:
Subject: Re: Need Help on query tuning
Next
From: Stephan Szabo
Date:
Subject: Re: Explicit Cast