| From: | "Larry Rosenman" <ler(at)lerctr(dot)org> |
|---|---|
| To: | "'Oleg Bartunov'" <oleg(at)sai(dot)msu(dot)su> |
| Cc: | <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: Creating an index-type for LIKE '%value%' |
| Date: | 2005-02-08 16:34:37 |
| Message-ID: | E1CyYKY-0002Vc-ND@lerami.lerctr.org |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
Oleg Bartunov wrote:
> On Tue, 8 Feb 2005, Larry Rosenman wrote:
>
>>
>> It doesn't seem to like pieces with hyphens ('-') in the name, when I
>> try To update blacklist set new_domain_lt=text2ltree(domain) I get a
>> Syntax error (apparently for the hyphens).
>>
>
> Try change definition of ISALNUM on ltree.h
>
> #define ISALNUM(x) ( isalnum((unsigned char)(x)) || (x) == '_' )
>
> this was already discussed
> http://www.pgsql.ru/db/mw/msg.html?mid=2034299
>
Thanks!
Now, how can I make it always case-insensitive?
--
Larry Rosenman http://www.lerctr.org/~ler
Phone: +1 972-414-9812 E-Mail: ler(at)lerctr(dot)org
US Mail: 1905 Steamboat Springs Drive, Garland, TX 75044-6749
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Oleg Bartunov | 2005-02-08 17:00:44 | Re: Creating an index-type for LIKE '%value%' |
| Previous Message | Berend Tober | 2005-02-08 16:27:25 | Re: create aggregates to concatenate |