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
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 |