Weird behavior

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

Browse pgsql-general by date

  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