| From: | Oleg Bartunov <oleg(at)sai(dot)msu(dot)su> |
|---|---|
| To: | Larry Rosenman <ler(at)lerctr(dot)org> |
| Cc: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: Creating an index-type for LIKE '%value%' |
| Date: | 2005-02-08 15:57:20 |
| Message-ID: | Pine.GSO.4.62.0502081855480.2906@ra.sai.msu.su |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
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
>
>
>
Regards,
Oleg
_____________________________________________________________
Oleg Bartunov, sci.researcher, hostmaster of AstroNet,
Sternberg Astronomical Institute, Moscow University (Russia)
Internet: oleg(at)sai(dot)msu(dot)su, http://www.sai.msu.su/~megera/
phone: +007(095)939-16-83, +007(095)939-23-83
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Berend Tober | 2005-02-08 16:27:25 | Re: create aggregates to concatenate |
| Previous Message | Bruce Momjian | 2005-02-08 15:41:18 | Re: [COMMITTERS] How I can add new function writing on C under Win32 |