Squeal.PostgreSQL.Manipulation.Update

Contents

Description

update statements

Synopsis

update :: (Has sch db schema, Has tab schema (Table table), Updatable table updates, SListI row) => QualifiedAlias sch tab -> NP (Aliased (Optional (Expression Ungrouped '[] '[] db params '[tab ::: TableToRow table]))) updates -> Condition Ungrouped '[] with db params '[tab ::: TableToRow table] -> ReturningClause with db params '[tab ::: TableToRow table] row -> Manipulation with db params row
update_ :: (Has sch db schema, Has tab schema (Table table), Updatable table updates) => QualifiedAlias sch tab -> NP (Aliased (Optional (Expression Ungrouped '[] '[] db params '[tab ::: TableToRow table]))) updates -> Condition Ungrouped '[] with db params '[tab ::: TableToRow table] -> Manipulation with db params '[]

Update

Arguments

:: (Has sch db schema, Has tab schema (Table table), Updatable table updates, SListI row)
=> QualifiedAlias sch tab	table to update
-> NP (Aliased (Optional (Expression Ungrouped '[] '[] db params '[tab ::: TableToRow table]))) updates	modified values to replace old values
-> Condition Ungrouped '[] with db params '[tab ::: TableToRow table]	condition under which to perform update on a row
-> ReturningClause with db params '[tab ::: TableToRow table] row	results to return
-> Manipulation with db params row

An update command changes the values of the specified columns in all rows that satisfy the condition.

Arguments

:: (Has sch db schema, Has tab schema (Table table), Updatable table updates)
=> QualifiedAlias sch tab	table to update
-> NP (Aliased (Optional (Expression Ungrouped '[] '[] db params '[tab ::: TableToRow table]))) updates	modified values to replace old values
-> Condition Ungrouped '[] with db params '[tab ::: TableToRow table]	condition under which to perform update on a row
-> Manipulation with db params '[]

Update a row returning Nil.