| From: | Fernando Schapachnik <fpscha(at)ns1(dot)via-net-works(dot)net(dot)ar> |
|---|---|
| To: | pgsql-general(at)postgresql(dot)org |
| Subject: | Strage behavior |
| Date: | 2001-02-02 16:01:31 |
| Message-ID: | 200102021601.NAA36729@ns1.via-net-works.net.ar |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
Sorry, I'm resending due to wrong subject.
-------------
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
----- End of forwarded message from Fernando Schapachnik -----
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Alfonso Peniche | 2001-02-02 16:43:44 | Re: sintax??? |
| Previous Message | chris markiewicz | 2001-02-02 15:45:12 | RE: Too many clients. |