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

[Karsten Hilbert]

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

Karsten
-- 
GPG key ID E4071346 @ wwwkeys.pgp.net
E167 67FD A291 2BEA 73BD  4537 78B9 A9F9 E407 1346