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. Everything in this table is stored in upper case to make searches simple (don't have to worry about mixed case. Just convert the word being searched for to upper and you're good to go). Here is a simple sample session using psql to show the table structure and two queries. Why isn't the upper() function working in the first query? Later, John Cochran ---------------------------- bash-2.03$ psql dt Welcome to psql, the PostgreSQL interactive terminal. Type: \copyright for distribution terms \h for help with SQL commands \? for help on internal slash commands \g or terminate with semicolon to execute query \q to quit dt=> \d abbreviation Table "abbreviation" Attribute | Type | Modifier -----------+----------+---------- word | char(15) | not null abbr | char(4) | Index: abbreviation_pkey dt=> select * from abbreviation where word = upper('Boulevard'); word | abbr ------+------ (0 rows) dt=> select * from abbreviation where word = 'BOULEVARD'; word | abbr -----------------+------ BOULEVARD | BLVD (1 row) dt=> \q