Michael Monnerie <michael.monnerie@is.it-management.at> wrote:
> On Sonntag 13 September 2009 Michael Monnerie wrote:
>> I currently have no idea how to cast bytea to text. For this
>> purpose of searching through mails, it would be enough for
>> postgres to treat the bytea as text, and just search through it.
>> You can only find ascii chars then, but that's a limitation one
>> can live with.
> Ping?
Nothing here works for you?:
http://www.postgresql.org/docs/8.4/interactive/functions-string.html
I would have thought convert_from, possibly combined with convert,
would do it.
-Kevin