 | Documentation |
|---|---|
DELETESynopsisDELETE FROM [ ONLY ] table [ WHERE condition ]
DELETE FROM table [ WHERE condition ]
[ RETURNING { * | return_expression [, ...] }
[ INTO { record | variable [, ...] } ] ]
DescriptionDELETE deletes rows that satisfy the WHERE clause from the specified table. If the WHERE clause is absent, the effect is to delete all rows in the table. The result is a valid, but empty table.
By default, DELETE will delete rows in the specified table and all its subtables. If you wish to only delete from the specific table mentioned, you must use the ONLY clause. If using RETURNING, the clause, INTO { record | variable [, ...] }, must be specified if DELETE is used as a program statement in a procedure, function, package, trigger, or anonymous block. INTO { record | variable [, ...] } must be omitted if the command is not given within the context of a program - for example as a stand-alone query in PSQL or SQL Interactive. If RETURNING * is specified, the effect is the same as if RETURNING return_expression [, ...] was given where each return_expression is a column in table, for each column in table, given in the same order as the columns in table. In an SPL program, if the result set of the DELETE command contains more than one row, then the contents of the target record or variables of the INTO clause are set to the RETURNING clause expressions based on one arbitrary row of the result set. If the result set is empty, then the contents of the target record or variables are set to null. You must have the DELETE privilege on the table to delete from it, as well as the SELECT privilege for any table whose values are read in the condition. Parameters
OutputsOn successful completion, a DELETE command returns a command tag of the form DELETE count The count is the number of rows deleted. If count is 0, no rows matched the condition (this is not considered an error). |