| From: | Rhaoni Chiu Pereira <rhaoni(at)sistemica(dot)info> |
|---|---|
| To: | Lista PostgreSQL <pgsql-admin(at)postgresql(dot)org> |
| Subject: | Explicit Cast |
| Date: | 2003-08-20 12:24:28 |
| Message-ID: | 1061382268.3f43687cc3565@sistemica.info |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | 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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Somasekhar Bangalore | 2003-08-20 12:28:59 | Need Help on query tuning |
| Previous Message | Raigo | 2003-08-20 10:41:03 | Starting PostgreSQL 7.3.4 with Webmin on Mandrake 9.1 |