You can create an '=' operator for those two types. Look at the "CREATE
OPERATOR" command, listed in the "SQL Commands" section of the Reference
Manual. That manual comes with your distribution, and also can be accessed
via any of the PostgreSQL mirror sites (check www.postgresql.org to find
one near you).
----- Original Message -----
From: "Pls Help Me" <plshelpme@my-deja.com>
To: <pgsql-general@postgresql.org>
Sent: Wednesday, August 29, 2001 5:13 AM
Subject: [GENERAL] Is it possible to default all number data to numeric
type?
> 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.
>
> ---------------------------(end of broadcast)---------------------------
> TIP 5: Have you checked our extensive FAQ?
>
> http://www.postgresql.org/users-lounge/docs/faq.html
>
>