John, are you using the IHASH for performance reasons? For several versions now, R:Base text index performance is really very good.
--- John Docherty <[EMAIL PROTECTED]> wrote: > I have a computed column (deh) using the IHASH function (on column de5) > which I thought would convert different strings to different hash values. I > have found a problem where the strings are different, (first character only > in this case) but the hash values are the same. Have I misunderstood what > should be happening here, or is something not quite right ? > > > R>sel de5=40 deh from rates where deh=963864368 > de5 deh > ---------------------------------------- ---------- > 350spirosetplaininsulated 963864368 > 250spirosetplaininsulated 963864368 > > R>list col deh > Column Name Table Name Attributes > ------------------ ------------------ > --------------------------------------- > deH rateskeep Type : INTEGER > > Compute: (IHASH(de5,0)) > > rates Type : INTEGER > > Compute: (IHASH(de5,0)) > > Any advice on this would be appreciated. > > Thank you. > > Regards, > > John Docherty > > > -- > No virus found in this outgoing message. > Checked by AVG Anti-Virus. > Version: 7.0.306 / Virus Database: 266.2.0 - Release Date: 21/02/2005 > > > ===== Albert Berry Management Consultant RR2 - 1252 Ponderosa Drive Sparwood BC, V0B 2G2 Canada (250) 425-5806 (250) 425-7259 (708) 575-3952 (fax) [EMAIL PROTECTED]
