search numerics

[sourceuno]

I want to be able to search numerics, such as "3.8", in my database. I read in a previous post to use the following statements:

<sql "set addexp='\alnum{1,99}'"></sql>
<sql "set addexp='\digit+:=\digit+'"></sql>

Do I need recreate the metamorph indexes that already exist on my table?

[mark]

I assume you're referring to
http://thunderstone.master.com/texis/ma ... 3aa7027f10

The first thing that does is drop the existing index. It also uses "delexp" which is important.
Yes, you have to rebuild the index to change index expressions.

And you'll want "\." instead of ":" in the second expression you mention.

[sourceuno]

After I create my indexes this way, do I need to do the same each time that I need to recreate the indexes?

[Kai]

If you're truly re-creating the indexes -- dropping them first and then re-making -- yes. If you're just updating -- re-issuing the create statement without dropping -- then no, the delexp/addexp expressions from the original Metamorph index create are remembered and do not need to be re-issued.