Strange Type Mismatch on Insert
От | Jeff Eckermann |
---|---|
Тема | Strange Type Mismatch on Insert |
Дата | |
Msg-id | 08CD1781F85AD4118E0800A0C9B8580B0949AF@NEZU обсуждение исходный текст |
Ответы |
Re: Strange Type Mismatch on Insert
|
Список | pgsql-general |
Can anyone see what is the problem with the following insert? gmp=# insert into data (site, gmp_id, item, category, gmp) values ('Rochester', 22, 'Design fee', 12, 40000.00); ERROR: Unable to identify an operator '=' for types 'text' and 'int4' You will have to retype this query using an explicit cast gmp=# \d data Table "data" Attribute | Type | Modifier -----------+---------------+------------------------ site | text | not null gmp_id | integer | not null default 9999 co_id | text | not null default 'N/A' item | text | not null category | integer | gmp | numeric(12,2) | default 0 co_status | char(1) | Index: data_pkey jeffe@kiyoko=> psql -V psql (PostgreSQL) 7.0.0 jeffe@kiyoko=> uname -a FreeBSD kiyoko.la.verio.net 4.0-STABLE FreeBSD 4.0-STABLE #0: Thu Apr 27 10:44:07 CDT 2000
В списке pgsql-general по дате отправления: