Michael Monnerie <michael.monnerie@xxxxxxxxxxxxxxxxxxx> 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 -- Sent via pgsql-admin mailing list (pgsql-admin@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin
