David Wheeler wrote:
> Any idea why = works here and LIKE and ~ wouldn't?
Because LIKE does a character-by-character matching and = uses the
operating system locale, which could do anything. If you set the
locale to C, you should get matching results. Which one is "better"
depends on the semantics of the language, which I cannot judge here.
--
Peter Eisentraut
http://developer.postgresql.org/~petere/