On Dienstag 15 September 2009 Kevin Grittner wrote:
> http://www.postgresql.org/docs/8.4/interactive/functions-string.html
>
> I would have thought convert_from, possibly combined with convert,
> would do it.
That function exists since 8.3, I'm on 8.1 on my server. Will forward it
to others, an
Michael Monnerie 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 a
On Sonntag 13 September 2009 Michael Monnerie wrote:
> On Donnerstag 10 September 2009 Tom Lane wrote:
> > There has *never* been a Postgres release that accepted bytea ILIKE
> > something. I'm not sure what you were really doing before, but
> > that wasn't it.
>
> You're right: That query was gen
On Donnerstag 10 September 2009 Tom Lane wrote:
> There has *never* been a Postgres release that accepted bytea ILIKE
> something. I'm not sure what you were really doing before, but that
> wasn't it.
You're right: That query was generated on a specific search, and doesn't
work. It's a bug that
Michael Monnerie writes:
> in dbmail there's a query that worked until postgresql 8.2 (i stripped
> the unneeded parts for other tables):
> SELECT k.messageblk FROM dbmail_messageblks k WHERE k.messageblk ILIKE
> '%multipart/encrypted%';
> In 8.3, you get an error
There has *never* been a P
