On Donnerstag 10 September 2009 Michael Monnerie wrote: > So, this is the query you posted stripped down: > SELECT k.messageblk FROM dbmail_messageblks k WHERE > k.messageblk ILIKE '%multipart/encrypted%'; > > He's right, that query doesn't work on PG 8.1 either.
OK, this is a bug in dbmail, which can be fixed in PostgreSQL 8.3 and up: http://www.postgresql.org/docs/8.4/interactive/functions-string.html I would have thought convert_from, possibly combined with convert, would do it. And this should really do the magic, but I'm on 8.1 today, will test on 8.3 soon. mfg zmi -- // Michael Monnerie, Ing.BSc ----- http://it-management.at // Tel: 0660 / 415 65 31 .network.your.ideas. // PGP Key: "curl -s http://zmi.at/zmi.asc | gpg --import" // Fingerprint: AC19 F9D5 36ED CD8A EF38 500E CE14 91F7 1C12 09B4 // Keyserver: wwwkeys.eu.pgp.net Key-ID: 1C1209B4 _______________________________________________ DBmail mailing list [email protected] http://mailman.fastxs.nl/cgi-bin/mailman/listinfo/dbmail
