Return to replace.nr CVS log

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

Annotation of 42BSD/ingres/doc/quel/replace.nr, revision 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.