[Solved] Identify the error in this composite type usage:CREATE TYPE employee AS (name text, age integer);CREATE TABLE staff (id serial, info employee);INSERT INTO staff (info) VALUES ('John', 30); | PostgreSQL

PostgreSQL - Advanced Features

Identify the error in this composite type usage:

CREATE TYPE employee AS (name text, age integer);
CREATE TABLE staff (id serial, info employee);
INSERT INTO staff (info) VALUES ('John', 30);

AIncorrect insertion syntax for composite type value

BComposite type not created before table

CMissing PRIMARY KEY in table

DComposite type fields must be declared as NOT NULL

Step-by-Step Solution

Solution:

Step 1: Check insertion syntax for composite types
Composite type values must be inserted as a single composite value, not separate fields.
Step 2: Identify correct insertion method
Use ROW('John', 30) or a composite literal, not separate values.
Final Answer:
Incorrect insertion syntax for composite type value -> Option A
Quick Check:
Insert composite as ROW(...) or composite literal [OK]

Quick Trick: Insert composite values using ROW(...) or composite literals [OK]

Common Mistakes:

Master "Advanced Features" in PostgreSQL

9 interactive learning modes - each teaches the same concept differently

Identify the error in this composite type usage: