Return to delete.nr CVS log

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

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