Strange Postgres Error

ERROR: operator does not exist: smallint == integer

[vincevincevince]

UPDATE trips SET "city"=2303,"start"=1121058000,"end"=1122613200,"owner"=5,"overlap"=1 WHERE tripid = 30

PHP Warning: pg_query(): Query failed: ERROR: operator does not exist: smallint == integer\nHINT: No operator matches the given name and argument type(s). You may need to add explicit type casts.

Does anyone have any idea what could be wrong?

tripid integer
owner integer
start integer
end integer
status boolean
city integer
overlap smallint
startlap integer
endlap integer

[ChadSEO]

Since you only have one smallint in your table, I'm guessing it's the "overlap" that is causing you problems. You should be able to fix it by doing:

UPDATE trips SET "city"=2303,"start"=1121058000,"end"=1122613200,"owner"=5,"overlap"=smallint '1' WHERE tripid = 30

[vincevincevince]

Thanks Chad - I have done that and it worked - but something is seriously odd as smallint should be able to handle '5'...