| From: | Fernando Schapachnik <fpscha(at)ns1(dot)via-net-works(dot)net(dot)ar> |
|---|---|
| To: | pgsql-general(at)postgresql(dot)org |
| Subject: | Stalled post to pgsql-general |
| Date: | 2001-02-02 15:41:08 |
| Message-ID: | 200102021541.MAA24603@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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Anand Raman | 2001-02-02 15:43:33 | plpgsql always returning null.. |
| Previous Message | Fernando Schapachnik | 2001-02-02 15:24:14 | Weird behavior |