David,
> Any idea why = works here and LIKE wouldn't?
Yes. I believe that LIKE relies on the database encoding, whereas = does a
direct byte comparison. However, I don't have much experience with encoding
issues, so you might be better off asking someone else.
I also recall there there were problems with multi-byte LIKE still being
worked on in 8.0.
One question, though, what do you get if you do:
bric=# select * from keyword where name ~ '^λΆνμ';
--
Josh Berkus
Aglio Database Solutions
San Francisco