Return to append.nr CVS log

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

Annotation of 43BSD/ingres/doc/quel/append.nr, revision 1.1.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.