Re: Strage behavior

En un mensaje anterior, Tom Lane escribió:
> Fernando Schapachnik <fpscha(at)ns1(dot)via-net-works(dot)net(dot)ar> writes:
> > select * from aliases where alias~'^claudia.gonzalez$' \g
> > alias|receptores
> > -----+----------
> > (0 rows)
>
> > select * from aliases where alias~'claudia.gonzalez$' \g
> > alias |receptores
> > ----------------+----------
> > claudia.gonzalez|claudia
> > (1 row)
>
> > Seems like there is some kind of unvisible char at the front.
>
> I think you are getting bitten by the LIKE-index-optimization problem.
> Are you running in a non-ASCII locale?

Yes, I am.

>
> There's a good deal of traffic concerning this issue in the archives,
> so I won't repeat it ...

Now I know the keyword :) I will search the archives. Thanks!

Fernando P. Schapachnik
Administración de la red
VIA NET.WORKS ARGENTINA S.A.
fschapachnik(at)vianetworks(dot)com(dot)ar
Conmutador: (54-11) 4323-3333 - Soporte: 0810-333-AYUDA