[GENERAL] Problem with upper() in select statement

2000-06-12 Thread John Cochran
Greetings, I'm having problems with what I believe to be a simple query and I assume that either there is a bug in PostgreSQL in handling functions during a select or I'm doing something very stupid. I have a table of words and abbreviations where the word is being used as a primary key.

Re: [GENERAL] Problem with upper() in select statement

2000-06-12 Thread Tom Lane
John Cochran [EMAIL PROTECTED] writes: John Cochran [EMAIL PROTECTED] 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? Nope, using the