Wow very nice. I would not have found that easily even if I read the pgcrypto doco from top to bottom.

In our case, a LIKE %search_term% search takes about 1 minute to search a 1 million row table, and that same search only takes 2-4 seconds when encrypted in s2k-mode = 1.

Thank you.