[SQL] odd error updating - varchar

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

Re: [SQL] odd error updating - varchar

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.

Re: [SQL] SELECT MAX returns wrong value

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