Re: IN clause on BYTEA column works against table directly but gives error against view - Mailing list pgsql-bugs

From Kevin Grittner
Subject Re: IN clause on BYTEA column works against table directly but gives error against view
Date
Msg-id 4D189AAD0200002500038BD2@gw.wicourts.gov
Whole thread Raw
In response to IN clause on BYTEA column works against table directly but gives error against view  (Eric Schwarzenbach <subscriber@blackbrook.org>)
List pgsql-bugs
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

pgsql-bugs by date:

Previous
From: Eric Schwarzenbach
Date:
Subject: IN clause on BYTEA column works against table directly but gives error against view
Next
From: Bruce Momjian
Date:
Subject: Re: BUG #5781: unaccent() function should be marked IMMUTABLE