Strange Type Mismatch on Insert

From: Jeff Eckermann <jeckermann(at)verio(dot)net>
To: "'pgsql-general(at)postgresql(dot)org'" <pgsql-general(at)postgresql(dot)org>
Subject: Strange Type Mismatch on Insert
Date: 2001-03-19 23:44:02
Message-ID: 08CD1781F85AD4118E0800A0C9B8580B0949AF@NEZU
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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(at)kiyoko=> psql -V
psql (PostgreSQL) 7.0.0
jeffe(at)kiyoko=> uname -a
FreeBSD kiyoko.la.verio.net 4.0-STABLE FreeBSD 4.0-STABLE #0: Thu Apr 27
10:44:07 CDT 2000

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Bruce Momjian 2001-03-20 00:17:36 Re: [GENERAL] Re: temp table creation
Previous Message Richard Huxton 2001-03-19 22:57:51 Re: concurrent updates problem