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
