From: | Fernando Schapachnik <fpscha(at)ns1(dot)via-net-works(dot)net(dot)ar> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | Weird behavior |
Date: | 2001-02-02 15:24:14 |
Message-ID: | 200102021524.MAA13259@ns1.via-net-works.net.ar |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | 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(at)vianetworks(dot)com(dot)ar
Conmutador: (54-11) 4323-3333 - Soporte: 0810-333-AYUDA
From | Date | Subject | |
---|---|---|---|
Next Message | Fernando Schapachnik | 2001-02-02 15:41:08 | Stalled post to pgsql-general |
Previous Message | Adam Lang | 2001-02-02 15:21:40 | Postgres users/groups |