DO INSTEAD in rule

Hi,

In the last SELECT I exepcted j = 0, rather than j = 1 since I use DO
INSTEAD in the rule and the default value for j is 0. Am I missing
something?

DROP TABLE t1 CASCADE;
DROP TABLE
CREATE TABLE t1 (i INTEGER,j INTEGER DEFAULT 0
);
CREATE TABLE
CREATE rule t1_ins AS ON INSERT TO t1WHERE (EXISTS (SELECT 1 FROM t1        WHERE i = new.i))DO INSTEAD UPDATE t1 SET j
=j + 1WHERE i = new.i;
 
CREATE RULE
INSERT INTO t1 VALUES (1);
INSERT 1690668 1
SELECT * FROM t1;i | j 
---+---1 | 1
(1 row)
--
Tatsuo Ishii