Skip site navigation (1) Skip section navigation (2)

strange problem

From: "Böhm, Sebastian (Vendor)" <sebastian(dot)boehm(at)friendscout24(dot)de>
To: "'pgsql-bugs(at)postgresql(dot)org'" <pgsql-bugs(at)postgresql(dot)org>
Subject: strange problem
Date: 2002-12-18 15:38:53
Message-ID: F11E485B8CEDD5119AAA000102F4030E2DBCE7@esdeklnbdcxc.internal.friendscout24.de (view raw or flat)
Thread:
Lists: pgsql-bugs
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

Responses

pgsql-bugs by date

Next:From: Bruno Wolff IIIDate: 2002-12-18 15:45:34
Subject: Re: COPY problem with bad dates
Previous:From: Bruno Wolff IIIDate: 2002-12-18 15:14:18
Subject: COPY problem with bad dates

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group