Re: IN clause on BYTEA column works against table directly but gives error against view

Eric Schwarzenbach <subscriber@blackbrook.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