Return to append.nr CVS log

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

Annotation of 42BSD/ingres/doc/quel/append.nr, revision 1.1

1.1     ! root        1: .th APPEND QUEL 1/26/79
        !             2: .sh NAME
        !             3: append \- append tuples to a relation
        !             4: .sh SYNOPSIS
        !             5: .bd append 
        !             6: [\c
        !             7: .bd to\c
        !             8: ] relname (target_list) [\c
        !             9: .bd where 
        !            10: qual\c
        !            11: ]
        !            12: .sh DESCRIPTION
        !            13: .it Append 
        !            14: adds tuples which satisfy the qualification to 
        !            15: .it relname.
        !            16: .it Relname 
        !            17: must be the name of an existing relation.
        !            18: The 
        !            19: .it target_list 
        !            20: specifies
        !            21: the values of the attributes to be appended to 
        !            22: .it relname.
        !            23: The domains may be listed in any order.
        !            24: Attributes of the result relation which do not appear in the 
        !            25: .it target_list
        !            26: as result_attnames (either explicitly or by default)
        !            27: are assigned default values of 0, for numeric attributes, or blank,
        !            28: for character attributes.
        !            29: 
        !            30: Values or expressions of any numeric type may be used to
        !            31: set the value of a numeric type domain. Conversion to the result domain
        !            32: type takes place.
        !            33: Numeric values cannot be directly assigned to
        !            34: character domains.
        !            35: Conversion from numeric to character can be done using
        !            36: the
        !            37: .bd ascii
        !            38: operator (see quel(quel)).
        !            39: Character values cannot be directly assigned to numeric domains.
        !            40: Use the 
        !            41: .bd int1\c
        !            42: ,
        !            43: .bd int2\c
        !            44: , etc. functions to convert
        !            45: character values to numeric (see quel(quel)).
        !            46: .s3
        !            47: The keyword 
        !            48: .bd all 
        !            49: can be used when it is desired
        !            50: to append all domains of a relation.
        !            51: .s3
        !            52: An
        !            53: .it append
        !            54: may only be issued by the owner of the relation
        !            55: or a user with 
        !            56: .it append
        !            57: permission on the given relation.
        !            58: .sh EXAMPLE
        !            59: .nf
        !            60: /\*(** Make new employee Jones work for Smith \*(**/
        !            61:    range of n is newemp
        !            62:    append to emp(n.name, n.sal, mgr = "Smith", bdate = 1975\-n.age)
        !            63:                where n.name = "Jones"
        !            64: /\*(** Append the newemp1 relation to newemp \*(**/
        !            65:    range of n1 is newemp1
        !            66:    append to newemp(n1.all)
        !            67: .fi
        !            68: .sh "SEE ALSO"
        !            69: copy(quel), permit(quel), quel(quel), retrieve(quel)
        !            70: .sh DIAGNOSTICS
        !            71: Use of a numeric type expression to set a character type domain or vice versa will
        !            72: produce diagnostics.
        !            73: .sh BUGS
        !            74: Duplicate tuples appended to a relation stored as a ``paged heap''
        !            75: (unkeyed, unstructured) are not removed.

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