From: | plshelpme(at)my-deja(dot)com (Pls Help Me) |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | Is it possible to default all number data to numeric type? |
Date: | 2001-08-29 10:13:47 |
Message-ID: | 114e101c.0108290213.80e8c99@posting.google.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
My company had a old program with written by Powerbuilder. It work
fine in MSSQL 6.5.
Now, my boss required to use another SQL server. Someone told me
PostgreSQL is totally free and powerful. I installed it in a Linux
machine (RedHat 7 + PostgreSQL 7.1.2), and transfer the old data from
MSSQL 6.5 server. It work fine.
However, when I run the old program. When I try to update some record
with numeric type field, it show error as below.
Unable to identify an operator '=' for types 'numeric' and 'float8'...
You will have to retype this query using an explicit cast.
The point is the software house closed, I can't find any programmer.
>_<
So, I want to know is it possible to set the numeric type to default??
Or any easy way to fix it up?
P.S. My English is bad, pls. forgive me.
From | Date | Subject | |
---|---|---|---|
Next Message | Justin Clift | 2001-08-29 10:42:25 | Re: RFC: PostgreSQL and MySQL comparison. |
Previous Message | omid omoomi | 2001-08-29 10:11:16 | Re: [SQL] getting the oid for a new tuple in a BEFORE trigger |