head     1.5;
branch   ;
access   ;
symbols  ;
locks    ; strict;
comment  @# @;


1.5
date     91.03.19.18.28.25;  author kemnitz;  state Exp;
branches ;
next     1.4;

1.4
date     91.03.19.16.30.06;  author kemnitz;  state Exp;
branches ;
next     1.3;

1.3
date     91.03.19.15.51.56;  author kemnitz;  state Exp;
branches ;
next     1.2;

1.2
date     91.03.19.15.08.44;  author kemnitz;  state Exp;
branches ;
next     1.1;

1.1
date     91.03.19.00.24.52;  author kemnitz;  state Exp;
branches ;
next     ;


desc
@@


1.5
log
@Re-arranged somewhat.
@
text
@/*
 * and update a newly added instance
 */
replace emp1 (salary = 2500) where emp1.name = "joe" and emp1.dept = "shoe"
\p
@


1.4
log
@Oops!  Jumbled around checkin rather massively!
@
text
@d2 1
a2 1
 * and update an employee in the version and in the base table
d4 1
a4 2

replace emp1 (salary = 5000) where emp1.name = "bill"
@


1.3
log
@demo shuffling
@
text
@d1 2
a2 3
/* 
 * we can also use rule to handle view updates.
 * For example, to handle insertion to toyemp we can define the rule:
d4 2
a5 4
define rule toyemp_app is
on append to toyemp do instead
append emp(name = new.name, age = new.age, location = new.location,
	dept = "toy", salary = new.annualsal/12)
@


1.2
log
@reorganized demo scripts
@
text
@d1 3
a3 2
/*
 * and update an employee in the version and in the base table
d5 4
a8 2

replace emp1 (salary = 5000) where emp1.name = "bill"
@


1.1
log
@Initial revision
@
text
@d1 5
a5 2
define view toyemp (emp.name, emp.age, emp.location, annualsal = 12*emp.salary)
where emp.dept = "toy"
@