> It seems to me that the problem is comming from the BYTEA type, not from the
> prepared statement by itself: As far as I know the only operator supported
> by BYTEA is concatenation. You can't even compare two BYTEA for (in)equality
> - even less using the LIKE operator.
Right, I suspected that too, as I've been reading a little bit around.
But...why if I manually query with a SQL client (AquaStudio) as
SELECT myfield FROM mytable WHERE myfield LIKE '%hello%'
and 'myfield' is a bytea field I get the result I expected? What's the
"trick" the client uses behind the curtains?
In response to
pgsql-jdbc by date
|Next:||From: Damiano Bolzoni||Date: 2009-08-31 06:08:43|
|Subject: Re: Search content within a bytea field|
|Previous:||From: Tom Lane||Date: 2009-08-30 22:58:49|
|Subject: Re: Search content within a bytea field |