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