Re: Search content within a bytea field

From: Thomas Kellerer <spam_eater(at)gmx(dot)net>
To: pgsql-jdbc(at)postgresql(dot)org
Subject: Re: Search content within a bytea field
Date: 2009-08-31 14:21:16
Message-ID: h7gm8l$u2k$1@ger.gmane.org
Views: Raw Message | Whole Thread | Download mbox
Thread:
Lists: pgsql-jdbc

Damiano Bolzoni, 31.08.2009 08:06:
> 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
> follows:
>
> 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?

This looks _very_ strange (if not even wrong) to me.

If you are storing character data, why don't you use the text datatype?

Thomas

In response to

Browse pgsql-jdbc by date

  From Date Subject
Next Message Ľubomír Varga 2009-08-31 19:34:12 Possible bug in PGInterval class
Previous Message Tom Lane 2009-08-31 14:11:11 Re: Search content within a bytea field