Re: [SQL] lower/upper functions and strings in searches

2003-08-14 Thread Stephan Szabo
On Thu, 14 Aug 2003, Gregory S. Williamson wrote: I am obviuously doing some newbie trick, and I ordinarily would spend time browing the archives, but the archives.postgresql.org site seems to be absurdly slow. This is 7.3.3 on a linux box. I have a bunch of data with state, city, county

Re: [SQL] lower/upper functions and strings in searches

2003-08-14 Thread Josh Berkus
Gregory, I just know I'm overlooking some real obvious thing but for some reason this eludes me. I could see if the search was very slow (the function returns type text and the indexed columns are of type CHAR(). Char(what?) ? if it's, say CHAR(4) that could be your problem; 'NM'::undefined