[GENERAL] new and old not available in rule subselects?

[Egil Möller]

It seems like you can not use the magical relations new and old in
sub-selects in rules. Why is this, or is there something I haven't
understood correctly about rules and new and old?

create table "user" (
 username varchar,
 created timestamp  default now(),
 detstroyed timestamp default null);

create table users (
 time timestamp,
 users bigint);

create rule user_insert_count as
 on update to "user"
 do also
  select
   new.created, (select count(*) from new where destroyed is null)
  into users
  from new;

ERROR:  relation "*NEW*" does not exist

Thanks in advance,
Egil

begin:vcard
fn;quoted-printable:Egil M=C3=B6ller
n;quoted-printable:M=C3=B6ller;Egil
email;internet:[EMAIL PROTECTED]
tel;cell:+46-(0)709-707207
url:http://redhog.org
version:2.1
end:vcard

signature.asc
Description: OpenPGP digital signature