[Gnumed-devel] Re: re searching scalars in text fields.

[Hilmar Berger]

syan tan schrieb:

  gnumed-public=# select narrative from clin_history where  to_number(
  substring( narrative from 'year:([0         -9]*)'), '9999' )  >= 1999;
   narrative
  -----------
   ---
    significant:1
    condition:wisdom tooth
    active:0
    year:1999
    laterality:none
    operation:0
    confidential:0
    notes:""

  I wonder how long it would take on 10,000 records?

It would not work. You would have to split the fields at the field separator
("\n") and search then in the respectice field only. 
You can't know the length of freetext fields beforehand and you can't search
for keywords because those can appear in text 
fields, too.

Hilmar




-- 
NEU FÜR ALLE - GMX MediaCenter - für Fotos, Musik, Dateien...
Fotoalbum, File Sharing, MMS, Multimedia-Gruß, GMX FotoService

Jetzt kostenlos anmelden unter http://www.gmx.net

+++ GMX - die erste Adresse für Mail, Message, More! +++