Squeal.PostgreSQL.Manipulation.Delete

delete statements

Delete

deleteFrom

Arguments

:: (SListI row, Has sch db schema, Has tab schema (Table table))

=> QualifiedAlias sch tab

table to delete from

-> UsingClause with db params from

-> Condition Ungrouped '[] with db params ((tab ::: TableToRow table) ': from)

condition under which to delete a row

-> ReturningClause with db params '[tab ::: TableToRow table] row

results to return

-> Manipulation with db params row

Delete rows from a table.

deleteFrom_

Arguments

:: (Has sch db schema, Has tab schema (Table table))

=> QualifiedAlias sch tab

table to delete from

-> Condition Ungrouped '[] with db params '[tab ::: TableToRow table]

condition under which to delete a row

-> Manipulation with db params '[]

Delete rows returning Nil.

data UsingClause with db params from where

Specify additional tables with Using an also list of table expressions, allowing columns from other tables to appear in the WHERE condition. This is similar to the list of tables that can be specified in the FROM Clause of a SELECT statement; for example, an alias for the table name can be specified. Do not repeat the target table in the Using list, unless you wish to set up a self-join. NoUsing if no additional tables are to be used.

Constructors

NoUsing :: UsingClause with db params '[]

Using

Fields

• :: FromClause '[] with db params from

  what to use

• -> UsingClause with db params from