INSERT with RETURNING clause in PostgreSQL - Interactive Code Practice

Practice - 5 Tasks

1fill in blank

easy

Complete the code to insert a new user and return the inserted id.

PostgreSQL

INSERT INTO users (name, email) VALUES ('Alice', '[e-mail]') [1] id;

Drag options to blanks, or click blank then click option'

AOUTPUT

BSELECT

CRETURNING

DFETCH

Attempts:

3 left

💡 Hint

Common Mistakes

Using SELECT instead of RETURNING after INSERT.

Forgetting to specify the column after RETURNING.

The RETURNING clause in PostgreSQL allows you to get the inserted row's columns immediately after an INSERT.

2fill in blank

medium

Complete the code to insert a product and return both id and name.

PostgreSQL

INSERT INTO products (name, price) VALUES ('Book', 9.99) [1] id, name;

Drag options to blanks, or click blank then click option'

ARETURNING

BFETCH

CSELECT

DOUTPUT

Attempts:

3 left

💡 Hint

Common Mistakes

Using OUTPUT which is not valid in PostgreSQL.

Trying to use SELECT after INSERT.

Use RETURNING to get multiple columns from the inserted row.

3fill in blank

hard

Fix the error in the code to return the inserted row's email.

PostgreSQL

INSERT INTO customers (name, email) VALUES ('Bob', '[e-mail]') [1] email;

Drag options to blanks, or click blank then click option'

AFETCH

BRETURNING

COUTPUT

DSELECT

Attempts:

3 left

💡 Hint

Common Mistakes

Using SELECT instead of RETURNING.

Using OUTPUT which is for other SQL dialects.

The correct keyword to return inserted columns in PostgreSQL is RETURNING.

4fill in blank

hard

Fill both blanks to insert a new order and return order_id and total.

PostgreSQL

INSERT INTO orders (customer_id, total) VALUES (123, 45.67) [1] [2];

Drag options to blanks, or click blank then click option'

ARETURNING

BSELECT

Corder_id, total

DOUTPUT

Attempts:

3 left

💡 Hint

Common Mistakes

Using OUTPUT which is not valid in PostgreSQL.

Putting SELECT instead of RETURNING.

Use RETURNING followed by the columns you want to get back, separated by commas.

5fill in blank

hard

Fill all three blanks to insert a new employee and return id and name.

PostgreSQL

INSERT INTO employees (name, department, salary) VALUES ('Eve', 'HR', 60000) [1] [2] [3];

Drag options to blanks, or click blank then click option'

ARETURNING

Bname

Cdepartment

Did,

Attempts:

3 left

💡 Hint

Common Mistakes

Forgetting commas between column names.

Using OUTPUT instead of RETURNING.

The RETURNING clause is followed by the columns you want to get back. Separate columns with commas. Here, id, name are returned (note the commas).