Stalled post to pgsql-general

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: 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

Browse pgsql-general by date

  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