Return to replace.nr CVS log

Up to [CSRG BSD Unix] / 43BSD / ingres / doc / quel

Annotation of 43BSD/ingres/doc/quel/replace.nr, revision 1.1.1.1

1.1       root        1: .th REPLACE QUEL 2/29/79
                      2: .sh NAME
                      3: replace \- replace values of domains in a relation
                      4: .sh SYNOPSIS
                      5: .bd replace
                      6: tuple_variable (target_list)
                      7: [\c
                      8: .bd where
                      9: qual]
                     10: .sh DESCRIPTION
                     11: .it Replace 
                     12: changes the values of
                     13: the domains specified in the 
                     14: .it target_list 
                     15: for all tuples which
                     16: satisfy the qualification 
                     17: .it qual.
                     18: The 
                     19: .it tuple_variable 
                     20: must have been declared to range over
                     21: the relation which is to be modified.
                     22: Note that a tuple variable is required and
                     23: not the relation name.
                     24: Only domains which are to be modified need appear in the 
                     25: .it target_list.
                     26: These domains must be specified as result_attnames 
                     27: in the 
                     28: .it target_list 
                     29: either explicitly or by default (see quel(quel)).
                     30: 
                     31: Numeric domains may be replaced by values of any numeric type 
                     32: (with the exception noted below).
                     33: Replacement values will be converted to the type of the result domain.
                     34: .s1
                     35: Only the owner of a relation, or a user with 
                     36: replace pemission on the relation can do 
                     37: .it replace.
                     38: .s1
                     39: If the tuple update would violate an integrity constraint 
                     40: (see integrity(quel)), it is not done.
                     41: .sh EXAMPLE
                     42: .nf
                     43: /\*(** Give all employees who work for Smith a 10% raise \*(**/
                     44:    range of e is emp
                     45:    replace e(sal = 1.1 \*(** e.sal) where e.mgr = "Smith"
                     46: .fi
                     47: .sh "SEE ALSO"
                     48: integrity(quel), permit(quel), quel(quel), range(quel)
                     49: .sh DIAGNOSTICS
                     50: Use of a numeric type expression to replace a character type domain
                     51: or vice versa will produce diagnostics.
                     52: .sh BUGS

This archive runs on limited infrastructure. Preserving old code on modern bandwidth. Automated agents are requested to crawl responsibly.