I am trying to update a table and I'm getting an odd error. I've narrowed it
down to one attribute, but can't see what the prolem is.
Anyone got any ideas?
goole=# update requests set r_chassis = 'GAJD7P26209' where r_id = 18560;
ERROR: attribute 7 has wrong type
DETAIL: Table has type charac
Gary Stainburn <[EMAIL PROTECTED]> writes:
> goole=# update requests set r_chassis = 'GAJD7P26209' where r_id = 18560;
> ERROR: attribute 7 has wrong type
> DETAIL: Table has type character varying, but query expects character
> varying.
This looks like a bug that was fixed awhile ago.
On Dec 13, 2007 5:09 PM, Gavin Baumanis <[EMAIL PROTECTED]> wrote:
> Hi Everyone,
>
> Sorry if I am missing something obvious but I think I have found a bug.
> If I perform the following SQL
>
> SELECT MAX(column) FROM table WHERE expression
>
> and there is no match, Postgres returns a record coun