Tag Archives: type cast

I recently did a select similar to the following, where a subquery grabs some ids, and then a main query uses them: select * from attributes where id in ( select id from documents where owner = 'sam' ); But I got the following error: ERROR:  operator does not exist: integer = text HINT:  No [...]