[Top][All Lists]
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Gnumed-devel] boolean trigger xor behaviour
From: |
syan tan |
Subject: |
[Gnumed-devel] boolean trigger xor behaviour |
Date: |
Sun, 23 Nov 2003 10:44:57 +1100 |
User-agent: |
Mozilla/5.0 (X11; U; Linux i686; en-US; rv:1.3) Gecko/20030313 |
gnumed=# update names set active = 't';
UPDATE 2
gnumed=# select * from names;
id | id_identity | active | lastnames | firstnames | preferred | title
----+-------------+--------+-----------+------------+-----------+-------
4 | 1 | t | Bill | Brown | |
5 | 2 | t | Edna | Smythe | |
(2 rows)
gnumed=# update names set active = 't';
UPDATE 0
gnumed=# select * from names;
id | id_identity | active | lastnames | firstnames | preferred | title
----+-------------+--------+-----------+------------+-----------+-------
4 | 1 | f | Bill | Brown | |
5 | 2 | f | Edna | Smythe | |
(2 rows)
gnumed=# update names set active = 't';
UPDATE 2
gnumed=# select * from names;
id | id_identity | active | lastnames | firstnames | preferred | title
----+-------------+--------+-----------+------------+-----------+-------
4 | 1 | t | Bill | Brown | |
5 | 2 | t | Edna | Smythe | |
(2 rows)
Why?
[Prev in Thread] |
Current Thread |
[Next in Thread] |
- [Gnumed-devel] boolean trigger xor behaviour,
syan tan <=