In Kmail, I start a search for "Full message" (that's "Vollständige Nachricht" in german) with content ZMI_FullMessage on an IMAP Folder. The IMAP command generated is: 104860 UID SEARCH TEXT "ZMI_FullMessage"
And the resulting SELECT is: SELECT m.message_idnr, v.headervalue, k.messageblk FROM dbmail_messageblks k JOIN dbmail_physmessage p ON k.physmessage_id=p.id JOIN dbmail_messages m ON m.physmessage_id=p.id JOIN dbmail_headervalue v ON v.physmessage_id=p.id WHERE m.mailbox_idnr=3324 AND m.status in (0,1) HAVING SUBSTRING(v.headervalue,0,255) ILIKE '%ZMI_FullMessage%' OR k.messageblk ILIKE '%ZMI_FullMessage%' This SELECT produced an error on PostgreSQL 8.3: ERROR: operator does not exist: bytea ~~* unknown ZEILE 1: ...,0,255) ILIKE '%ZMI_FullMessage%' OR k.messageblk ILIKE '%ZM... TIP: No operator matches the given name and argument type(s). You might need to add explicit type casts. After changing that to "OR k.messageblk::Text ILIKE '%ZMI_FullMessage%';" (you see, I only casted k.messageblk to a Text field, and tried with varchar also for the same result) I got the error: ERROR: column "m.message_idnr" must appear in the GROUP BY clause or be used in an aggregate function Still dbmail returns several messages: * SEARCH 3635587 (and about 20 other numbers) 104860 OK SEARCH completed And those messages for sure do not contain what I searched for. 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-dev mailing list [email protected] http://twister.fastxs.net/mailman/listinfo/dbmail-dev
