Sim Zacks wrote: > 2) Wouldn't the query be much faster if the > ENCODE(k.messageblk::bytea,'escape') LIKE '%sim%' was in the WHERE > clause instead of the HAVING clause?
Try it. Afaik, it simply wont work. > 3) Does anybody have imap search working on some reasonable level? Very good question. The only solution I can think of is full text indexing. -- ________________________________________________________________ Paul Stevens paul at nfg.nl NET FACILITIES GROUP GPG/PGP: 1024D/11F8CD31 The Netherlands________________________________http://www.nfg.nl _______________________________________________ DBmail mailing list [email protected] https://mailman.fastxs.nl/mailman/listinfo/dbmail
