| 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: | Whole Thread | Raw Message | 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 |