From: | Daniel Kalchev <daniel(at)digsys(dot)bg> |
---|---|
To: | t-ishii(at)sra(dot)co(dot)jp |
Cc: | pgsql-hackers(at)postgresql(dot)org |
Subject: | Re: [HACKERS] another locale problem |
Date: | 1999-06-11 09:32:09 |
Message-ID: | 199906110932.MAA25757@dcave.digsys.bg |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
This worked, however it made all selects of ~* '^sometext' sequential.
Why can't we use index searches in this case? I believe it is :-)
But this
SELECT key FROM t WHERE key ~* '^ sometext';
(note the space after the carret) still does not work! It says index scan will
be used and finds nothng. If 'sometext' is all uppercase the proper result is
returned. The problem seems to be in the regex handling anyway. I tried
compiling regcomp.c with -funsigned-char, but that was not enough. Further
hacking...
Daniel
>>>Tatsuo Ishii said:
> Ok. Now I almost certain that:
>
> (strcmp(opname,"~*")
> == 0 && isalpha((unsigned char)n->val.val.str[pos])))
>
> should work for you. Can you confirm this?
> --
> Tatsuo Ishii
From | Date | Subject | |
---|---|---|---|
Next Message | Daniel Kalchev | 1999-06-11 09:36:31 | Re: [HACKERS] another locale problem |
Previous Message | Angelos Karageorgiou | 1999-06-11 08:49:50 | Re: [HACKERS] another locale problem |