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

[syan tan]

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:""
---
 significant:1
 condition:fractured femur
 active:0
 year:1999
 laterality:none
 operation:0
 confidential:0
 notes:skiing|colarado
(2 rows)

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