[Top][All Lists]

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Re: [Gnumed-devel] Searching (Was: ha)

From: Karsten Hilbert
Subject: Re: [Gnumed-devel] Searching (Was: ha)
Date: Tue, 1 Apr 2003 10:53:40 +0200
User-agent: Mutt/

PostgreSQL cannot do indexed searches on:

 - case-INsensitive operators (ilike, ~*)
 - non-anchored search terms (.*cker)
 - parts of a view without known data about the table
   underlying that part of the view (hence the addition of
   n_id to v_basic_person)

I am unsure as to the applicability of indices to soundex()ed
search terms - you'd need a soundex()ed index, too.

> Or even Baecker
Handled already.

>, But this is what soundex algorithms are for.
Soundex isn't well understood for any language other than
English AFAICT.

> I still think non-indexed searches should be the 
> exception - waiting a second or more for a *routine* query result is not 
> acceptable.
It would be helpful if clinicians specified what a *routine*
query IS. I have defined *my* opinion in working code. Go beat

GPG key ID E4071346 @
E167 67FD A291 2BEA 73BD  4537 78B9 A9F9 E407 1346

reply via email to

[Prev in Thread] Current Thread [Next in Thread]