Simon Riggs <[EMAIL PROTECTED]> 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
---------------------------(end of broadcast)---------------------------
TIP 4: Have you searched our list archives?
http://archives.postgresql.org
