[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/1.3.22.1i |
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