A. R. Van Hook wrote:
I have two tables defined as:
checks
(ckidint NOT null PRIMARY KEY,
payto text,
notes text,
ckdate date,
printed int default 0,
tdate timestamp
6 15:10:23 +0200
Subject: Re: [SQL] new rule syntax?
[UTF-8?]> A. R. Van Hook напиÑа:
> > I have two tables defined as:
> > checks
> >(ckidint NOT null PRIMARY KEY,
> > payto text,
> > notes
A. R. Van Hook написа:
I have two tables defined as:
checks
(ckidint NOT null PRIMARY KEY,
payto text,
notes text,
ckdate date,
printed int default 0,
tdate timestamp
am 05.02.2006, um 6:00:18 -0600 mailte A. R. Van Hook folgendes:
> in previous versions (<8.1) the following rule declaration seemed to work
> fine
> create rule checks_d0 as
> on delete to checks
> do delete from checkitems
>where ckid = checks.ckid;
> in 8.1.2 I get
>
I have two tables defined as:
checks
(ckidint NOT null PRIMARY KEY,
payto text,
notes text,
ckdate date,
printed int default 0,
tdate timestamp not null)
checkitems