Explicit Cast - Mailing list pgsql-admin

From Rhaoni Chiu Pereira
Subject Explicit Cast
Date
Msg-id 1061382268.3f43687cc3565@sistemica.info
Whole thread Raw
Responses Re: Explicit Cast
List 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 by date:

Previous
From: "Nick Fankhauser"
Date:
Subject: Re: changing field length
Next
From: "Somasekhar Bangalore"
Date:
Subject: Need Help on query tuning