gnumed-devel
[Top][All Lists]
Advanced

[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?





reply via email to

[Prev in Thread] Current Thread [Next in Thread]