Strage behavior

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

Responses

Browse pgsql-general by date

  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.