Simon Riggs <simon(at)2ndquadrant(dot)com> writes:
> ...which is fine on just one table, but I want to join...
> postgres=# select * from c where col1 = any (select col2 from c);
> ERROR: operator does not exist: integer = integer[]
That isn't a join. Are you looking for something like
select * from c, c as c2 where c.col1 = any (c2.col2)
regards, tom lane