Weird behavior - Mailing list pgsql-general

From Fernando Schapachnik
Subject Weird behavior
Date
Msg-id 200102021524.MAA13259@ns1.via-net-works.net.ar
Whole thread Raw
List pgsql-general
Hello:
    First of all, forgive me if this is not the appropiate list
for my problem.

    What happens is: 6.5.0 running whitout problem for a very
long time. Suddenly:

select * from aliases where alias ~'claudia.gonzalez' \g
alias           |receptores
----------------+----------
claudia.gonzalez|claudia
(1 row)

    BUT:

select * from aliases where alias ='claudia.gonzalez' \g
alias|receptores
-----+----------
(0 rows)

    Also:

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.

    Any ideas? TIA!

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

pgsql-general by date:

Previous
From: Alfonso Peniche
Date:
Subject: Re: sintax???
Next
From: Tony Grant
Date:
Subject: Re: sintax???