Update DELETE Statement Documentation to Include RETURNING Clause

[rustyconover]

What happens?

I noticed that the documentation for the DELETE statement currently doesn’t mention that a RETURNING clause can be added to return the values of the deleted rows. Since this is such a useful feature, adding it to the documentation with a quick example would be really helpful for users.

Thanks for considering this enhancement, and for all the great work you’re doing with the docs! 😊

To Reproduce

create table employees(name text, age int);
insert into employees values ('Kat', 32);
delete from employees returning name, age;

delete from employees returning name, age;
┌─────────┬───────┐
│  name   │  age  │
│ varchar │ int32 │
├─────────┼───────┤
│ Kat     │    32 │
└─────────┴───────┘

OS:

Mac OS X

DuckDB Version:

v1.1.2 f680b7d08f

DuckDB Client:

CLI

Hardware:

No response

Full Name:

Rusty Conover

Affiliation:

self

What is the latest build you tested with? If possible, we recommend testing with the latest nightly build.

I have tested with a stable release

Did you include all relevant data sets for reproducing the issue?

No - Other reason (please specify in the issue body)

Did you include all code required to reproduce the issue?

• Yes, I have

Did you include all relevant configuration (e.g., CPU architecture, Python version, Linux distribution) to reproduce the issue?

• Yes, I have

[szarnyasg]

Hi @rustyconover, thanks! Indeed this is missing. I transferred this issue to the duckdb-web repository where the documentation site and will resolve it next week.