Paul,
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.
That depends on whether you're trying to return just a list of IDs, or the full contents of the messages. If you just need a list of IDs, you can use the WHERE clause.
--Josh _______________________________________________ DBmail mailing list [email protected] https://mailman.fastxs.nl/mailman/listinfo/dbmail
