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 ---------------------------(end of broadcast)--------------------------- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]