Solution:Step 1: Check partition column data typePartitioning by RANGE requires a column with an orderable type like numeric or date, not TEXT.Step 2: Identify the error causeHere, region is TEXT, so RANGE partitioning on it is invalid.Final Answer:Partitioning by RANGE requires a numeric or date ty

[Solved] You wrote this code:CREATE TABLE logs (id INT, region TEXT, day DATE) PARTITION BY RANGE (region) SUBPARTITION BY LIST (day);What is the error in this statement? | PostgreSQL

PostgreSQL - Table Partitioning

You wrote this code:

CREATE TABLE logs (id INT, region TEXT, day DATE) PARTITION BY RANGE (region) SUBPARTITION BY LIST (day);

What is the error in this statement?

ARANGE partitioning cannot be done on a TEXT column

BPartitioning by RANGE requires a numeric or date type, not TEXT

CSyntax error: SUBPARTITION BY must come before PARTITION BY

DSUBPARTITION BY LIST cannot be used with RANGE partitioning

Step-by-Step Solution

Solution:

Step 1: Check partition column data type
Partitioning by RANGE requires a column with an orderable type like numeric or date, not TEXT.
Step 2: Identify the error cause
Here, region is TEXT, so RANGE partitioning on it is invalid.
Final Answer:
Partitioning by RANGE requires a numeric or date type, not TEXT -> Option B
Quick Check:
RANGE needs numeric/date, not TEXT [OK]

Quick Trick: RANGE partition needs numeric or date column [OK]

Common Mistakes:

Thinking TEXT can be used for RANGE partitioning
Confusing order of PARTITION BY and SUBPARTITION BY
Assuming SUBPARTITION BY LIST is invalid with RANGE

Master "Table Partitioning" in PostgreSQL

9 interactive learning modes - each teaches the same concept differently

Learn Why Deep Visual Try Challenge Project Recall Time

You wrote this code:

Step 1: Check partition column data type

Step 2: Identify the error cause

Final Answer:

Quick Check:

Want More Practice?