Re: Is it possible to default all number data to numeric type?
От | Jeff Eckermann |
---|---|
Тема | Re: Is it possible to default all number data to numeric type? |
Дата | |
Msg-id | 054b01c13265$2642eb10$279c10ac@INTERNAL обсуждение исходный текст |
Ответ на | Is it possible to default all number data to numeric type? (plshelpme@my-deja.com (Pls Help Me)) |
Список | pgsql-general |
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 > >
В списке pgsql-general по дате отправления: