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'::undefin

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, cou

[SQL] lower/upper functions and strings in searches

2003-08-14 Thread Gregory S. Williamson
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 and country names. When our application does a search fo