John Cochran <jdc(at)fiawol(dot)org> writes:
> Why isn't the upper() function working in the first query?
Odd. You aren't by some chance working in a non-ASCII locale where
"upper('Boulevard')" yields something besides 'BOULEVARD', are you?
regards, tom lane