Return to delete.nr CVS log

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

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

1.1       root        1: .th DELETE QUEL 1/26/79
                      2: .sh NAME
                      3: delete \- delete tuples from a relation
                      4: .sh SYNOPSIS
                      5: .bd delete
                      6: tuple_variable 
                      7: [\c
                      8: .bd where
                      9: qual\c
                     10: ]
                     11: .sh DESCRIPTION
                     12: .it Delete 
                     13: removes tuples which satisfy the qualification 
                     14: .it qual 
                     15: from the
                     16: relation that they belong to.
                     17: The 
                     18: .it tuple_variable 
                     19: must have been declared
                     20: to range over an existing relation in a previous 
                     21: .it range 
                     22: statement.
                     23: .it Delete 
                     24: does not have a 
                     25: .it target_list.
                     26: The
                     27: .it delete 
                     28: command requires a
                     29: tuple variable from a 
                     30: .it range 
                     31: statement, and
                     32: not the actual relation name.
                     33: If the qualification is not given, the effect is to delete all
                     34: tuples in the relation.
                     35: The result is a valid, but empty relation.
                     36: .s3
                     37: To 
                     38: .it delete 
                     39: tuples from a relation, you must be the owner of the relation,
                     40: or have 
                     41: .it delete 
                     42: permission on the relation.
                     43: .sh EXAMPLE
                     44: .nf
                     45: /\*(** Remove all employees who make over $30,000 \*(**/
                     46:    range of e is emp
                     47:    delete e where e.sal > 30000
                     48: .fi
                     49: .sh "SEE ALSO"
                     50: destroy(quel), permit(quel), quel(quel), range(quel)
                     51: .sh BUGS

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