strange problem

Hi,

I don't know what is going on here. Maybe somebody can help.

Iam using postgresql 7.3.

ici=# select id,pseudonym from user_all where pseudonym =
'autologin_funkey';
id | pseudonym
----+-----------
(0 rows)

ici=# select id,pseudonym from user_all where pseudonym ~
'^autologin_funkey$';
id | pseudonym
------+------------------
6881 | autologin_funkey
(1 row)

ici=# update user_all set pseudonym = (select pseudonym from user_all where
pseudonym ~ '^autologin_funkey$') where pseudonym ~ '^autologin_funkey$';
UPDATE 1

ici=# select id,pseudonym from user_all where pseudonym =
'autologin_funkey';
id | pseudonym
------+------------------
6881 | autologin_funkey
(1 row)

Sebastian Böhm
Friendscout24.de