[Solved] Given the ENUM type and table below, what will be the result of the query?CREATE TYPE colors AS ENUM ('red', 'green', 'blue');... SELECT color FROM items ORDER BY color; | PostgreSQL

PostgreSQL - Advanced Features

Given the ENUM type and table below, what will be the result of the query?

CREATE TYPE colors AS ENUM ('red', 'green', 'blue');
CREATE TABLE items (id SERIAL PRIMARY KEY, color colors);
INSERT INTO items (color) VALUES ('green'), ('blue'), ('red');

SELECT color FROM items ORDER BY color;

Ared, blue, green

Bblue, green, red

Cgreen, blue, red

Dred, green, blue

Step-by-Step Solution

Solution:

Step 1: Understand ENUM ordering
ENUM values are ordered by their declaration order: 'red' < 'green' < 'blue'.
Step 2: Apply ORDER BY on color column
Ordering by color sorts rows as per ENUM order, so 'red', 'green', 'blue'.
Final Answer:
red, green, blue -> Option A
Quick Check:
ENUM order = declaration order [OK]

Quick Trick: ENUM sorts by declared order, not alphabetically [OK]

Common Mistakes:

Assuming alphabetical order instead of ENUM order
Confusing insertion order with sort order
Expecting default text sorting

Master "Advanced Features" in PostgreSQL

9 interactive learning modes - each teaches the same concept differently

Learn Why Deep Visual Try Challenge Project Recall Time

Given the ENUM type and table below, what will be the result of the query?

Step 1: Understand ENUM ordering

Step 2: Apply ORDER BY on color column

Final Answer:

Quick Check:

Want More Practice?