Eric Schwarzenbach <subscriber(at)blackbrook(dot)org> wrote:
> I've got a SELECT with a WHERE clause using IN against a BYTEA
> column which works when I'm querying against the table directly.
> However when I substitute an equivalent view in my query (a view
> made of several inner joins which simply carry over that same
> BYTEA column), I get the error:
>
> operator does not exist: "integer = bytea"
> My query is occurring via JDBC, using a prepared statement
Please submit a small, self-contained class which creates any needed
tables and views and then runs a query generates the error. The
smaller and simpler, the better.
-Kevin