| From: | Stephan Szabo <sszabo(at)megazone(dot)bigpanda(dot)com> |
|---|---|
| To: | Rhaoni Chiu Pereira <rhaoni(at)sistemica(dot)info> |
| Cc: | Lista PostgreSQL <pgsql-admin(at)postgresql(dot)org> |
| Subject: | Re: Explicit Cast |
| Date: | 2003-08-20 15:45:46 |
| Message-ID: | 20030820084251.T7072-100000@megazone.bigpanda.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin |
On Wed, 20 Aug 2003, Rhaoni Chiu Pereira 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 you send the actual function you're having problems with and version
information? I don't seem to get an error with a simple function that
uses such a construct on 7.3.4, but I expect the real example is more
complicated.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | scott.marlowe | 2003-08-20 15:48:39 | Re: changing field length |
| Previous Message | VanderLeeden | 2003-08-20 15:34:26 | DBMirror - Replicating binary objects of type bytea ? |